Conversion

TIMESTAMP_SECONDS

BigQueryBigQuery

Mengkonversi Unix timestamp (seconds) ke TIMESTAMP.

Tipe hasil: TIMESTAMPDiperbarui: 7 Jan 2026

Syntax

SQL
TIMESTAMP_SECONDS(int64_expression)

Parameter

int64_expressionINT64wajib

Detik sejak 1970-01-01 00:00:00 UTC

Contoh Penggunaan

Unix Seconds to TIMESTAMP

SQL
1SELECT
2  TIMESTAMP_SECONDS(0) as epoch,
3  TIMESTAMP_SECONDS(1704067200) as ts;

Konversi Unix timestamp ke TIMESTAMP.

Hasil
epochts
1970-01-01 00:00:002024-01-01 00:00:00

Fungsi Equivalen di Database Lain

MySQL

FROM_UNIXTIME

MySQL

Kembali ke BigQuery Functions