How to get it in programming languages...
Back to UNIX timestamp epoch converter »
Back to UNIX timestamp epoch converter »
UNIX timestamp
| Language | Function |
|---|---|
| C/C++ | time(0) |
| Perl | time |
| PHP | time() |
| Python | time.time() |
| Ruby | Time.now Time.now.to_i |
| JavaScript | Math.round(new Date().getTime()/1000.0) |
| Java | long unixtime = System.currentTimeMillis()/1000; |
| Microsoft .NET C# | unixtime = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000; |
| VBScript/ASP | DateDiff("s", "01/01/1970 00:00:00", 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()) |
| Unix/Linux shell | date +%s |