{"id":176,"date":"2013-03-11T12:39:35","date_gmt":"2013-03-11T11:39:35","guid":{"rendered":"http:\/\/sam-soul.fr\/Info\/?p=176"},"modified":"2013-03-11T12:39:35","modified_gmt":"2013-03-11T11:39:35","slug":"epoch","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2013\/03\/11\/epoch\/","title":{"rendered":"Epoch"},"content":{"rendered":"

http:\/\/www.epochconverter.com\/<\/a><\/span><\/p>\n

What is epoch time?<\/span><\/strong><\/h2>\n

The Unix epoch<\/strong> (or Unix time<\/strong> or POSIX time<\/strong> or Unix timestamp<\/strong>) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC\/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1\/1\/1970), but ‘epoch’ is often used as a synonym for ‘Unix time’. Many Unix systems store epoch dates as a signed 32-bit integer, which might cause problems on January 19, 2038 (known as the Year 2038 problem or Y2038).<\/span><\/p>\n\n\n\n\n\n\n\n\n
Human readable time<\/strong><\/span><\/td>\nSeconds<\/strong><\/span><\/td>\n<\/tr>\n
1 hour<\/span><\/td>\n3600 seconds<\/span><\/td>\n<\/tr>\n
1 day<\/span><\/td>\n86400 seconds<\/span><\/td>\n<\/tr>\n
1 week<\/span><\/td>\n604800 seconds<\/span><\/td>\n<\/tr>\n
1 month (30.44 days)<\/span><\/td>\n2629743 seconds<\/span><\/td>\n<\/tr>\n
1 year (365.24 days)<\/span><\/td>\n31556926 seconds<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

How to get the current epoch time in …<\/strong><\/span><\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
PHP<\/span><\/td>\ntime()<\/code> more …<\/a><\/span><\/td>\n<\/tr>\n
Python<\/span><\/td>\nimport time<\/code> first, then time.time()<\/code><\/span><\/td>\n<\/tr>\n
Ruby<\/span><\/td>\nTime.now<\/code> (or Time.new<\/code>). To display the epoch: Time.now.to_i<\/code><\/span><\/td>\n<\/tr>\n
Perl<\/span><\/td>\ntime<\/code> more …<\/a><\/span><\/td>\n<\/tr>\n
Java<\/span><\/td>\nlong epoch = System.currentTimeMillis()\/1000;<\/code><\/span><\/td>\n<\/tr>\n
Microsoft .NET C#<\/span><\/td>\nepoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) \/ 10000000;<\/code><\/span><\/td>\n<\/tr>\n
Objective-C<\/span><\/td>\n[[NSDate date] timeIntervalSince1970];<\/code> (returns double) or NSString *currentTimestamp = [NSString stringWithFormat:@\"%f\", [[NSDate date] timeIntervalSince1970]];<\/code><\/span><\/td>\n<\/tr>\n
VBScript\/ASP<\/span><\/td>\nDateDiff(\"s\", \"01\/01\/1970 00:00:00\", Now())<\/code><\/span><\/td>\n<\/tr>\n
Delphi<\/span><\/td>\nEpoch := DateTimetoUnix(Now);<\/code> Tested in Delphi 2010.<\/span><\/td>\n<\/tr>\n
R<\/span><\/td>\nas.numeric(Sys.time())<\/code><\/span><\/td>\n<\/tr>\n
Erlang<\/span><\/td>\ncalendar:datetime_to_gregorian_seconds(calendar:now_to_universal_time( now()))-719528*24*3600.<\/code><\/span><\/td>\n<\/tr>\n
MySQL<\/span><\/td>\nSELECT unix_timestamp(now())<\/code> more …<\/a><\/span><\/td>\n<\/tr>\n
PostgreSQL<\/span><\/td>\nSELECT extract(epoch FROM now());<\/code><\/span><\/td>\n<\/tr>\n
Oracle PL\/SQL<\/span><\/td>\nSELECT (SYSDATE - TO_DATE('01\/01\/1970 00:00:00', 'MM-DD-YYYY HH24:MI:SS')) *
\n24 * 60 * 60 FROM DUAL<\/code><\/span><\/td>\n<\/tr>\n
SQL Server<\/span><\/td>\nSELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())<\/code><\/span><\/td>\n<\/tr>\n
JavaScript<\/span><\/td>\nMath.round(new Date().getTime()\/1000.0)<\/code> getTime() returns time in milliseconds.<\/span><\/td>\n<\/tr>\n
Tcl\/Tk<\/span><\/td>\nclock seconds<\/code><\/span><\/td>\n<\/tr>\n
Unix\/Linux Shell<\/span><\/td>\ndate +%s<\/code><\/span><\/td>\n<\/tr>\n
PowerShell<\/span><\/td>\nGet-Date -UFormat \"%s\"<\/code> Produces: 1279152364.63599<\/span><\/td>\n<\/tr>\n
Other OS’s<\/span><\/td>\nCommand line: perl -e \"print time\"<\/code> (If Perl is installed on your system)<\/span><\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Convert from human readable date to epoch<\/span><\/strong><\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
PHP<\/span><\/td>\nstrtotime(\"15 November 2012\")<\/code> (converts most English date texts) or:
\ndate_create('01\/15\/2010')->format('U')<\/code> (PHP5 DateTime class) more …<\/a><\/span><\/td>\n<\/tr>\n
Python<\/span><\/td>\nimport time<\/code> first, then int(time.mktime(time.strptime('2000-01-01 12:34:00', '%Y-%m-%d %H:%M:%S'))) - time.timezone<\/code><\/span><\/td>\n<\/tr>\n
Ruby<\/span><\/td>\nTime.local(year<\/em>, month<\/em>, day<\/em>, hour<\/em>, minute<\/em>, second<\/em>, usec<\/em> )<\/code> (or Time.gm<\/code> for GMT\/UTC input). To display add .to_i<\/code><\/span><\/td>\n<\/tr>\n
Perl<\/span><\/td>\nUse the Perl Epoch routines<\/a><\/span><\/td>\n<\/tr>\n
Java<\/span><\/td>\nlong epoch = new java.text.SimpleDateFormat(\"MM\/dd\/yyyy HH:mm:ss\").parse(\"01\/01\/1970 01:00:00\").getTime() \/ 1000;<\/code><\/span><\/td>\n<\/tr>\n
VBScript\/ASP<\/span><\/td>\nDateDiff(\"s\", \"01\/01\/1970 00:00:00\", time field<\/em>)<\/code> \"More<\/a><\/span><\/td>\n<\/tr>\n
Delphi<\/span><\/td>\nEpoch := DateTimeToUnix(StrToDateTime(myString));<\/code><\/span><\/td>\n<\/tr>\n
C<\/span><\/td>\nUse the C Epoch Converter routines<\/a><\/span><\/td>\n<\/tr>\n
R<\/span><\/td>\nas.numeric(as.POSIXct(\"MM\/dd\/yyyy HH:mm:ss\", origin=\"1970-01-01\"))<\/code><\/span><\/td>\n<\/tr>\n
MySQL<\/span><\/td>\nSELECT unix_timestamp(time<\/em>)<\/code> Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
\nMore on using Epoch timestamps with MySQL<\/a><\/span><\/td>\n<\/tr>\n
PostgreSQL<\/span><\/td>\nSELECT extract(epoch FROM date('2000-01-01 12:34'));<\/code>
\nWith timestamp: SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-08');<\/code>
\nWith interval: SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');<\/code><\/span><\/td>\n<\/tr>\n
SQL Server<\/span><\/td>\nSELECT DATEDIFF(s, '1970-01-01 00:00:00', time field<\/em>)<\/code><\/span><\/td>\n<\/tr>\n
JavaScript<\/span><\/td>\nUse the JavaScript Date object<\/a><\/span><\/td>\n<\/tr>\n
Unix\/Linux Shell<\/span><\/td>\ndate +%s -d\"Jan 1, 1980 00:00:01\"<\/code> Replace ‘-d’ with ‘-ud’ to input in GMT\/UTC time.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Convert from epoch to human readable date<\/span><\/strong><\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
PHP<\/span><\/td>\ndate(output format<\/em>, epoch<\/em>);<\/code> Output format example: ‘r’ = RFC 2822 date more …<\/a><\/span><\/td>\n<\/tr>\n
Python<\/span><\/td>\nimport time<\/code> first, then time.strftime(\"%a, %d %b %Y %H:%M:%S +0000\", time.localtime(epoch<\/em>))<\/code> Replace time.localtime with time.gmtime for GMT time. \"More<\/a><\/span><\/td>\n<\/tr>\n
Ruby<\/span><\/td>\nTime.at(epoch<\/em>)<\/code><\/span><\/td>\n<\/tr>\n
Perl<\/span><\/td>\nUse the Perl Epoch routines<\/a><\/span><\/td>\n<\/tr>\n
Java<\/span><\/td>\nString date = new java.text.SimpleDateFormat(\"MM\/dd\/yyyy HH:mm:ss\").format(new java.util.Date (epoch<\/em>*1000));<\/code><\/span><\/td>\n<\/tr>\n
VBScript\/ASP<\/span><\/td>\nDateAdd(\"s\", epoch<\/em>, \"01\/01\/1970 00:00:00\")<\/code> \"More<\/a><\/span><\/td>\n<\/tr>\n
Delphi<\/span><\/td>\nmyString := DateTimeToStr(UnixToDateTime(Epoch));<\/code> Where Epoch is a signed integer.<\/span><\/td>\n<\/tr>\n
C<\/span><\/td>\nUse the C Epoch Converter routines<\/a><\/span><\/td>\n<\/tr>\n
Objective-C<\/span><\/td>\nNSDate * myDate = [NSDate dateWithTimeIntervalSince1970:epoch<\/em>]; NSLog(@\"%@\", date);<\/code><\/span><\/td>\n<\/tr>\n
R<\/span><\/td>\nas.POSIXct(epoch, origin=\"1970-01-01\", tz=\"GMT\")<\/code><\/span><\/td>\n<\/tr>\n
MySQL<\/span><\/td>\nFROM_UNIXTIME(epoch<\/em>, optional output format<\/em>)<\/code> Default output format is YYY-MM-DD HH:MM:SS. If you need support for negative timestamps: DATE_FORMAT(DATE_ADD(FROM_UNIXTIME(0), interval -315619200 second),\"%Y-%m-%d\")<\/code> (replace -315619200 with epoch) more …<\/a><\/span><\/td>\n<\/tr>\n
PostgreSQL<\/span><\/td>\nPostgreSQL version 8.1 and higher: SELECT to_timestamp(epoch<\/em>);<\/code> \"More<\/a> Older versions: SELECT TIMESTAMP WITH TIME ZONE 'epoch' + epoch<\/em> * INTERVAL '1 second';<\/code><\/span><\/td>\n<\/tr>\n
Oracle PL\/SQL<\/span><\/td>\nSELECT to_date('01-JAN-1970','dd-mon-yyyy')+(1326357743\/60\/60\/24) from dual<\/code>
\nReplace 1326357743 with epoch.<\/span><\/td>\n<\/tr>\n
SQL Server<\/span><\/td>\nDATEADD(s, epoch<\/em>, '1970-01-01 00:00:00')<\/code><\/span><\/td>\n<\/tr>\n
Microsoft Excel<\/span><\/td>\n=(A1 \/ 86400) + 25569<\/code> Format the result cell for date\/time, the result will be in GMT time (A1 is the cell with the epoch number). For other time zones: =((A1 +\/- time zone adjustment<\/a>) \/ 86400) + 25569.<\/span><\/td>\n<\/tr>\n
Crystal Reports<\/span><\/td>\nDateAdd(\"s\", {EpochTimeStampField}-14400, #1\/1\/1970 00:00:00#)<\/code> -14400 used for Eastern Standard Time. See Time Zones<\/a>.<\/span><\/td>\n<\/tr>\n
JavaScript<\/span><\/td>\nUse the JavaScript Date object<\/a><\/span><\/td>\n<\/tr>\n
Tcl\/Tk<\/span><\/td>\nclock format 1325376000<\/code> \"More<\/a><\/span><\/td>\n<\/tr>\n
Unix\/Linux Shell<\/span><\/td>\ndate -d @1190000000<\/code> Replace 1190000000 with your epoch, needs recent version of ‘date’. Replace ‘-d’ with ‘-ud’ for GMT\/UTC time.<\/span><\/td>\n<\/tr>\n
PowerShell<\/span><\/td>\nFunction get-epochDate ($epochDate) { [timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1\/1\/1970').AddSeconds($epochDate)) }<\/code>, then use: get-epochDate 1279152364<\/code>. Works for Windows PowerShell v1 and v2<\/span><\/td>\n<\/tr>\n
Other OS’s<\/span><\/td>\nCommand line: perl -e \"print scalar(localtime(epoch<\/em>))\"<\/code> (If Perl is installed) Replace ‘localtime’ with ‘gmtime’ for GMT\/UTC time.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

http:\/\/www.epochconverter.com\/ What is epoch time? The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC\/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1\/1\/1970), but ‘epoch’ is often used as … Continuer la lecture de « Epoch »<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/176"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}