| 語言 | 代碼示例 | 備註 |
|---|
| Java | System.currentTimeMillis() / 1000 | 毫秒轉秒 |
| JavaScript | Math.floor(Date.now() / 1000) | 或 Math.round(new Date().getTime()/1000) |
| C# / .NET | (DateTime.UtcNow.Ticks - 621355968000000000) / 10000000 | Ticks 從 0001-01-01 開始 |
| MySQL | SELECT UNIX_TIMESTAMP(NOW()) | |
| Perl | time | |
| PHP | time() | |
| PostgreSQL | SELECT EXTRACT(EPOCH FROM NOW()) | 返回浮點數 |
| Python | import time; int(time.time()) | |
| Ruby | Time.now.to_i | |
| SQL Server | SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) | |
| Linux Shell | date +%s | |
| VBScript/ASP | DateDiff("s", "01/01/1970 00:00:00", Now()) | |
| 命令行 | perl -e "print time" | 系統有 Perl 時通用 |
| 語言 | 代碼示例 |
|---|
| Java | new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date(timestamp * 1000L)) |
| JavaScript | new Date(timestamp * 1000).toLocaleString() |
| Linux | date -d @timestamp |
| MySQL | FROM_UNIXTIME(timestamp) |
| Perl | localtime(timestamp) 返回列表 |
| PHP | date('Y-m-d H:i:s', timestamp) |
| PostgreSQL | TIMESTAMP WITH TIME ZONE 'epoch' + timestamp * INTERVAL '1 second' |
| Python | time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(timestamp)) |
| Ruby | Time.at(timestamp).strftime('%Y-%m-%d %H:%M:%S') |
| SQL Server | DATEADD(s, timestamp, '1970-01-01 00:00:00') |
| VBScript | DateAdd("s", timestamp, "01/01/1970 00:00:00") |
| 語言 | 代碼示例 |
|---|
| Java | new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse("2023-01-01 12:00:00").getTime() / 1000 |
| JavaScript | Date.UTC(year, month-1, day, hour, minute, second) / 1000 |
| MySQL | UNIX_TIMESTAMP('2023-01-01 12:00:00') |
| Perl | use Time::Local; timelocal(sec, min, hour, day, month-1, year) |
| PHP | mktime(hour, minute, second, month, day, year) |
| PostgreSQL | EXTRACT(EPOCH FROM TIMESTAMP '2023-01-01 12:00:00') |
| Python | int(time.mktime(time.strptime('2023-01-01 12:00:00', '%Y-%m-%d %H:%M:%S'))) |
| Ruby | Time.local(year, month, day, hour, minute, second).to_i |
| SQL Server | DATEDIFF(s, '1970-01-01 00:00:00', '2023-01-01 12:00:00') |
| Linux | date +%s -d "2023-01-01 12:00:00" |
| VBScript | DateDiff("s", "01/01/1970 00:00:00", "2023-01-01 12:00:00") |
