Home
>
Program > How to get the current epoch time in …
How to get the current epoch time in …
Perl |
time |
PHP |
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. |
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 |
date +%s |
Other OS’s |
Command line: perl -e "print time" (If Perl is installed on your system) |
Spritez Program asp, c#, current time, erlang, java, javascript, Linux, mysql, oracle, perl, php, postgreSQL, python, rudy, SQL Server, timestamp, Unix