Conversion

DATE_FROM_UNIX_DATE

BigQuery

Mengkonversi jumlah hari sejak 1970-01-01 ke DATE.

Tipe hasil: DATEDiperbarui: 7 Jan 2026

Syntax

SQL

DATE_FROM_UNIX_DATE(int64_expression)

int64_expressionINT64wajib

Jumlah hari sejak Unix epoch

SQL

1 SELECT
2   DATE_FROM_UNIX_DATE(0) as epoch,
3   DATE_FROM_UNIX_DATE(19724) as some_date;

Konversi dari Unix date.

Hasil

epoch	some_date
1970-01-01	2024-01-01

1	SELECT
2	DATE_FROM_UNIX_DATE(0) as epoch,
3	DATE_FROM_UNIX_DATE(19724) as some_date;