当前 Unix 时间戳:
| Java | System.currentTimeMillis() / 1000 |
| JavaScript | Math.round(new Date().getTime() / 1000)getTime() 返回毫秒 |
| C# (.NET) | (DateTime.UtcNow - new DateTime(1970,1,1)).TotalSeconds |
| 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', GETUTCDATE()) |
| Linux / Unix | date +%s |
| VBScript | DateDiff("s", "01/01/1970 00:00:00", Now()) |
| 其他(Perl) | perl -e "print time" |
| JavaScript | new Date(unix * 1000).toLocaleString() |
| Linux | date -d @<timestamp> |
| MySQL | FROM_UNIXTIME(<timestamp>) |
| PHP | date('Y-m-d H:i:s', <timestamp>) |
| Python | time.strftime('%Y-%m-%d %H:%M:%S', time.gmtime(ts)) |
| Ruby | Time.at(<timestamp>) |
| JavaScript | new Date(Date.UTC(year, month-1, day, hour, min, sec)).getTime()/1000 - 8*3600 |
| PHP | mktime(hour, min, sec, month, day, year) |
| Python | int(time.mktime(time.strptime('YYYY-MM-DD HH:MM:SS', '%Y-%m-%d %H:%M:%S'))) |
| MySQL | UNIX_TIMESTAMP('YYYY-MM-DD HH:MM:SS') |
| Linux | date -d "Jan 1 2025 09:30:13" +%s |
Unix 时间戳(Unix timestamp)是从 1970 年 1 月 1 日 00:00:00 UTC 起至今的总秒数。 它被广泛用于 Unix、Linux、数据库及各类编程语言中,是系统间时间交换的标准格式。