Date & Time

TIME_ADD

BigQuery

Menambahkan interval waktu ke TIME. Berguna untuk kalkulasi jam kerja dan scheduling.

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

TIME_ADD(time_expression, INTERVAL int64_expression time_part)

Parameter

time_expressionTIMEwajib

TIME awal

int64_expressionINT64wajib

Jumlah interval yang ditambahkan

time_partTIME_PARTwajib

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

Contoh Penggunaan

Add Hours

SQL

1 SELECT
2   TIME '09:00:00' as start_time,
3   TIME_ADD(TIME '09:00:00', INTERVAL 8 HOUR) as end_time,
4   TIME_ADD(TIME '09:00:00', INTERVAL 30 MINUTE) as break_time;

Menambahkan jam dan menit.

Hasil

start_time	end_time	break_time
09:00:00	17:00:00	09:30:00

Wrap Around Midnight

SQL

1 SELECT
2   TIME '23:00:00' as late_night,
3   TIME_ADD(TIME '23:00:00', INTERVAL 3 HOUR) as past_midnight;

Hasil wrap around ke hari berikutnya.

Hasil

late_night	past_midnight
23:00:00	02:00:00

Kembali ke BigQuery Functions

1	SELECT
2	TIME '09:00:00' as start_time,
3	TIME_ADD(TIME '09:00:00', INTERVAL 8 HOUR) as end_time,
4	TIME_ADD(TIME '09:00:00', INTERVAL 30 MINUTE) as break_time;

1	SELECT
2	TIME '23:00:00' as late_night,
3	TIME_ADD(TIME '23:00:00', INTERVAL 3 HOUR) as past_midnight;