How To Get The Current Epoch Time (Unix Timestamp)


Perl time
PHP time()
Ruby (or To display the epoch:
Python import time first, then int(time.time())
Java long epoch = System.currentTimeMillis()/1000;
Microsoft .NET C# epoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000;
VBScript/ASP DateDiff("s", "01/01/1970 00:00:00", Now())
Erlang calendar:datetime_to_gregorian_seconds(calendar:now_to_universal_time( now()))-719528*24*3600.
element(1, now()) * 10000 + element(2, now()).
MySQL SELECT unix_timestamp(now())
PostgreSQL SELECT extract(epoch FROM now());
Oracle PL/SQL SELECT (SYSDATE - TO_DATE('01-01-1970 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) *
24 * 60 * 60 FROM DUAL
SQL Server SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())
JavaScript Math.round(new Date().getTime()/1000.0) getTime() returns time in milliseconds.
Unix/Linux Shell date +%s
PowerShell Get-Date -UFormat "%s" Produces: 1279152364.63599
Actionscript (new Date()).time
Other OS’s Command line: perl -e "print time" (If Perl is installed on your system)
ColdFusion (CFML) MX 6.1+ #int( getTickCount() / 1000 )#
Bash Command Line: date +%s

24 thoughts on “How To Get The Current Epoch Time (Unix Timestamp)

  1. Pingback: Tweets that mention How To Get The Current Epoch Time (Unix Timestamp) « Shafiq Issani --
  2. For some reason I get different timestamps from .NET script than PHP script. The machine is same. However, I found this little web page useful for testing conversions:

  3. There is a simpler way to do it in Erlang:

    element(1, now()) * 10000 + element(2, now()).

  4. I don’t think the oracle one is right. I am in Central Time in US. it returns and epoch time 6 hours earlier than now.

  5. So, I was googling (javascript epoch now).. planning to do the same for MYSQL, PHP.. and from the first search I found it all here, as the first suggested result by google, You deserve it, Thanks!

    I think this post will be in many developers bookmark forever, lol 🙂

Leave a Reply