Date & Time

TIMESTAMP_SUB

BigQuery

Mengurangi interval waktu dari TIMESTAMP. Kebalikan dari TIMESTAMP_ADD.

Tipe hasil: TIMESTAMPDiperbarui: 7 Jan 2026

Syntax

SQL

TIMESTAMP_SUB(timestamp_expression, INTERVAL int64_expression timestamp_part)

Parameter

timestamp_expressionTIMESTAMPwajib

TIMESTAMP awal

int64_expressionINT64wajib

Jumlah interval yang dikurangi

timestamp_partTIMESTAMP_PARTwajib

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

Contoh Penggunaan

Last Hour Filter

SQL

1 SELECT *
2 FROM `project.dataset.events`
3 WHERE event_time >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR);

Filter events dalam 1 jam terakhir.

Rolling Window

SQL

1 SELECT
2   TIMESTAMP_TRUNC(CURRENT_TIMESTAMP(), HOUR) as current_hour,
3   TIMESTAMP_SUB(TIMESTAMP_TRUNC(CURRENT_TIMESTAMP(), HOUR), INTERVAL 24 HOUR) as start_window;

Definisikan 24-hour rolling window.

Fungsi Terkait

TIMESTAMP_ADDTIMESTAMP_DIFF

Kembali ke BigQuery Functions

1	SELECT *
2	FROM `project.dataset.events`
3	WHERE event_time >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR);

1	SELECT
2	TIMESTAMP_TRUNC(CURRENT_TIMESTAMP(), HOUR) as current_hour,
3	TIMESTAMP_SUB(TIMESTAMP_TRUNC(CURRENT_TIMESTAMP(), HOUR), INTERVAL 24 HOUR) as start_window;