Date & Time

DATETIME_SUB

BigQuery

Mengurangi interval waktu dari DATETIME. Kebalikan dari DATETIME_ADD.

Tipe hasil: DATETIMEDiperbarui: 7 Jan 2026

Syntax

SQL

DATETIME_SUB(datetime_expression, INTERVAL int64_expression datetime_part)

Parameter

datetime_expressionDATETIMEwajib

DATETIME awal

int64_expressionINT64wajib

Jumlah interval yang dikurangi

datetime_partDATETIME_PARTwajib

Unit interval: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, etc.

Contoh Penggunaan

Subtract Intervals

SQL

1 SELECT
2   CURRENT_DATETIME() as now,
3   DATETIME_SUB(CURRENT_DATETIME(), INTERVAL 24 HOUR) as yesterday,
4   DATETIME_SUB(CURRENT_DATETIME(), INTERVAL 7 DAY) as week_ago;

Mengurangi berbagai interval.

Filter Recent Data

SQL

1 SELECT *
2 FROM `project.dataset.events`
3 WHERE event_datetime >= DATETIME_SUB(CURRENT_DATETIME(), INTERVAL 1 HOUR);

Filter events dalam 1 jam terakhir.

Kembali ke BigQuery Functions

1	SELECT
2	CURRENT_DATETIME() as now,
3	DATETIME_SUB(CURRENT_DATETIME(), INTERVAL 24 HOUR) as yesterday,
4	DATETIME_SUB(CURRENT_DATETIME(), INTERVAL 7 DAY) as week_ago;

1	SELECT *
2	FROM `project.dataset.events`
3	WHERE event_datetime >= DATETIME_SUB(CURRENT_DATETIME(), INTERVAL 1 HOUR);