Conversion

UNIX_TIMESTAMP

MySQL

Mengembalikan Unix timestamp (detik sejak 1970-01-01 00:00:00 UTC). Tanpa argumen = waktu sekarang.

Tipe hasil: BIGINTDiperbarui: 7 Jan 2026

Syntax

SQL

UNIX_TIMESTAMP([date])

dateDATE | DATETIME | TIMESTAMPopsional

Tanggal yang akan dikonversi (opsional)

SQL

1 SELECT UNIX_TIMESTAMP() AS now_unix;

Unix timestamp saat ini.

Hasil

now_unix: 1705334400 (varies)

SQL

1 SELECT UNIX_TIMESTAMP('2024-01-15 12:00:00') AS ts;

Konversi tanggal ke Unix timestamp.

Hasil

ts: 1705320000

SQL

1 SELECT UNIX_TIMESTAMP(end_time) - UNIX_TIMESTAMP(start_time) AS duration_sec
2 FROM sessions;

Hitung durasi dalam detik.

Hasil

duration_sec: 3600

DATE_PART

Snowflake

UNIX_SECONDS

BigQuery

1	SELECT UNIX_TIMESTAMP(end_time) - UNIX_TIMESTAMP(start_time) AS duration_sec
2	FROM sessions;