Date & Time

TIMESTAMP

BigQuery

Membuat nilai TIMESTAMP dari string, DATE, atau DATETIME. TIMESTAMP selalu disimpan dalam UTC.

Tipe hasil: TIMESTAMPDiperbarui: 7 Jan 2026

Syntax

SQL

TIMESTAMP(string_expression [, time_zone]) | TIMESTAMP(date [, time_zone]) | TIMESTAMP(datetime [, time_zone])

string_expressionSTRINGopsional

String timestamp untuk diparse

dateDATEopsional

DATE untuk dikonversi

datetimeDATETIMEopsional

DATETIME untuk dikonversi

time_zoneSTRINGopsional

Timezone untuk interpretasi input

SQL

1 SELECT
2   TIMESTAMP('2024-01-15 14:30:00') as ts_default,
3   TIMESTAMP('2024-01-15 14:30:00', 'Asia/Jakarta') as ts_jakarta;

Parse string ke TIMESTAMP dengan timezone.

Hasil

ts_default	ts_jakarta
2024-01-15 14:30:00 UTC	2024-01-15 07:30:00 UTC

SQL

1 SELECT
2   TIMESTAMP(DATE '2024-01-15') as ts_from_date,
3   TIMESTAMP(DATE '2024-01-15', 'Asia/Jakarta') as ts_jakarta;

Konversi DATE ke TIMESTAMP.

Hasil

ts_from_date	ts_jakarta
2024-01-15 00:00:00 UTC	2024-01-14 17:00:00 UTC

SQL

1 SELECT
2   TIMESTAMP(DATETIME '2024-01-15 14:30:00', 'Asia/Jakarta') as ts;

Konversi DATETIME ke TIMESTAMP dengan timezone.

Hasil

2024-01-15 07:30:00 UTC

1	SELECT
2	TIMESTAMP('2024-01-15 14:30:00') as ts_default,
3	TIMESTAMP('2024-01-15 14:30:00', 'Asia/Jakarta') as ts_jakarta;

1	SELECT
2	TIMESTAMP(DATE '2024-01-15') as ts_from_date,
3	TIMESTAMP(DATE '2024-01-15', 'Asia/Jakarta') as ts_jakarta;

1	SELECT
2	TIMESTAMP(DATETIME '2024-01-15 14:30:00', 'Asia/Jakarta') as ts;