Date & Time

TIME_SUB

BigQuery

Mengurangi interval waktu dari TIME. Kebalikan dari TIME_ADD.

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

TIME_SUB(time_expression, INTERVAL int64_expression time_part)

Parameter

time_expressionTIMEwajib

TIME awal

int64_expressionINT64wajib

Jumlah interval yang dikurangi

time_partTIME_PARTwajib

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

Contoh Penggunaan

Subtract Hours

SQL

1 SELECT
2   TIME '17:00:00' as end_time,
3   TIME_SUB(TIME '17:00:00', INTERVAL 8 HOUR) as start_time,
4   TIME_SUB(TIME '17:00:00', INTERVAL 30 MINUTE) as before_end;

Mengurangi jam dan menit.

Hasil

end_time	start_time	before_end
17:00:00	09:00:00	16:30:00

Before Midnight Wrap

SQL

1 SELECT
2   TIME '02:00:00' as early_morning,
3   TIME_SUB(TIME '02:00:00', INTERVAL 5 HOUR) as yesterday_night;

Wrap ke hari sebelumnya.

Hasil

early_morning	yesterday_night
02:00:00	21:00:00

Kembali ke BigQuery Functions

1	SELECT
2	TIME '17:00:00' as end_time,
3	TIME_SUB(TIME '17:00:00', INTERVAL 8 HOUR) as start_time,
4	TIME_SUB(TIME '17:00:00', INTERVAL 30 MINUTE) as before_end;

1	SELECT
2	TIME '02:00:00' as early_morning,
3	TIME_SUB(TIME '02:00:00', INTERVAL 5 HOUR) as yesterday_night;