Date & Time

TIMESTAMP_ADD

BigQuery

Menambahkan interval waktu ke TIMESTAMP. Hasil tetap dalam UTC.

Tipe hasil: TIMESTAMPDiperbarui: 7 Jan 2026

Syntax

SQL

TIMESTAMP_ADD(timestamp_expression, INTERVAL int64_expression timestamp_part)

timestamp_expressionTIMESTAMPwajib

TIMESTAMP awal

int64_expressionINT64wajib

Jumlah interval yang ditambahkan

timestamp_partTIMESTAMP_PARTwajib

Unit interval: DAY, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND

SQL

1 SELECT
2   TIMESTAMP '2024-01-15 10:00:00 UTC' as original,
3   TIMESTAMP_ADD(TIMESTAMP '2024-01-15 10:00:00 UTC', INTERVAL 6 HOUR) as plus_6h;

Menambahkan jam ke timestamp.

Hasil

original	plus_6h
2024-01-15 10:00:00 UTC	2024-01-15 16:00:00 UTC

SQL

1 SELECT
2   user_id,
3   login_time,
4   TIMESTAMP_ADD(login_time, INTERVAL 24 HOUR) as token_expires
5 FROM `project.dataset.user_sessions`;

Hitung waktu expiry token.

1	SELECT
2	TIMESTAMP '2024-01-15 10:00:00 UTC' as original,
3	TIMESTAMP_ADD(TIMESTAMP '2024-01-15 10:00:00 UTC', INTERVAL 6 HOUR) as plus_6h;

1	SELECT
2	user_id,
3	login_time,
4	TIMESTAMP_ADD(login_time, INTERVAL 24 HOUR) as token_expires
5	FROM `project.dataset.user_sessions`;