top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to get current time on various system (Unix Timestamp)

+8 votes
547 views
Perl                time
PHP                 time()
C/C++               time_t t = time()
Ruby                Time.now (or Time.new). To display the epoch: Time.now.to_i
Python              import time first, then 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.
OR
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: **********.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
posted Jan 21, 2014 by anonymous

  Promote This Article
Facebook Share Button Twitter Share Button LinkedIn Share Button

...