Unix 時間戳轉換工具

Math.floor(Date.now() / 1000)

import time
int(time.time())

time()

java.time.Instant.now().getEpochSecond()

import "time"
time.Now().Unix()

SELECT UNIX_TIMESTAMP();

SELECT FLOOR(EXTRACT(EPOCH FROM NOW()));

DateTimeOffset.UtcNow.ToUnixTimeSeconds()

date +%s

new Date(1767225600 * 1000).toISOString()

from datetime import datetime, timezone
datetime.fromtimestamp(1767225600, timezone.utc).isoformat()

gmdate('Y-m-d H:i:s', 1767225600)

java.time.Instant.ofEpochSecond(1767225600L)

time.Unix(1767225600, 0).UTC()

SET time_zone = '+00:00';
SELECT FROM_UNIXTIME(1767225600);

SET TIME ZONE 'UTC';
SELECT TO_TIMESTAMP(1767225600);

DateTimeOffset.FromUnixTimeSeconds(1767225600)

date -u -d @1767225600

Math.floor(new Date("2026-01-01T00:00:00Z").getTime() / 1000)

from datetime import datetime, timezone
int(datetime(2026, 1, 1, tzinfo=timezone.utc).timestamp())

(new DateTimeImmutable('2026-01-01T00:00:00Z'))->getTimestamp()

java.time.Instant.parse("2026-01-01T00:00:00Z").getEpochSecond()

time.Date(2026, 1, 1, 0, 0, 0, 0, time.UTC).Unix()

SET time_zone = '+00:00';
SELECT UNIX_TIMESTAMP('2026-01-01 00:00:00');

SELECT EXTRACT(EPOCH FROM TIMESTAMPTZ '2026-01-01 00:00:00+00');

new DateTimeOffset(2026, 1, 1, 0, 0, 0, TimeSpan.Zero).ToUnixTimeSeconds()

date -u -d '2026-01-01 00:00:00' +%s