Methods to get current time in milliseconds since the UNIX epoch (January 1, 1970 00:00:00 UTC) in various programming languages
ActionScript | (new Date()).time |
C++ | std::chrono::duration_cast<std::chrono::milliseconds>(std::chrono::system_clock::now().time_since_epoch()).count() |
C#.NET | DateTimeOffset.UtcNow.ToUnixTimeMilliseconds() |
Clojure | (System/currentTimeMillis) |
Dart | DateTime.now().millisecondsSinceEpoch |
Erlang | erlang:system_time(millisecond) |
Excel / Google Sheets* | = (NOW() – CELL_WITH_TIMEZONE_OFFSET_IN_HOURS/24 – DATE(1970,1,1)) * 86400000 |
Go / Golang | time.Now().UnixNano() / 1000000 |
Hive* | unix_timestamp() * 1000 |
Java / Groovy / Kotlin | System.currentTimeMillis() |
Javascript | Date.now() // or: new Date().getTime() |
MySQL* | UNIX_TIMESTAMP() * 1000 |
Objective-C | (long long)([[NSDate date] timeIntervalSince1970] * 1000.0) |
OCaml | (1000.0 *. Unix.gettimeofday ()) |
Oracle PL/SQL* | SELECT (SYSDATE-CAST(TO_TIMESTAMP_TZ(’01-01-1970 00:00:00+00:00′, ‘DD-MM-YYYY HH24:MI:SS TZH:TZM’) as date)) * 24 * 60 * 60 * 1000 FROM DUAL |
Perl | use Time::HiRes qw(gettimeofday); print gettimeofday; |
PHP | round(microtime(true) * 1000) |
PostgreSQL | extract(epoch FROM now()) * 1000 |
PowerShell | [double](Get-Date -Date ((Get-Date).ToUniversalTime()) -UFormat %s) * 1000 |
Python | int(round(time.time() * 1000)) |
Qt | QDateTime::currentMSecsSinceEpoch() |
R* | as.numeric(Sys.time()) * 1000 |
Ruby | (Time.now.to_f * 1000).floor |
Rust | std::time::SystemTime::now().duration_since(UNIX_EPOCH).expect(“error”) |
Scala | val timestamp: Long = System.currentTimeMillis |
SQL Server | DATEDIFF(ms, ‘1970-01-01 00:00:00’, GETUTCDATE()) |
SQLite* | STRFTIME(‘%s’, ‘now’) * 1000 |
Swift* | let currentTime = NSDate().timeIntervalSince1970 * 1000 |
VBScript / ASP | offsetInMillis = 60000 * WScript.Echo DateDiff(“s”, “01/01/1970 00:00:00”, Now()) * 1000 – offsetInMillis + Timer * 1000 mod 1000 |
CockroachDB | select extract(epoch_nanoseconds from now()) / 1000000 |
QA
How to get current time in milliseconds