Date & Time

DATETIME_ADD

BigQueryBigQuery

Menambahkan interval waktu ke DATETIME. Mendukung semua unit dari MICROSECOND hingga YEAR.

Tipe hasil: DATETIMEDiperbarui: 7 Jan 2026

Syntax

SQL
DATETIME_ADD(datetime_expression, INTERVAL int64_expression datetime_part)

Parameter

datetime_expressionDATETIMEwajib

DATETIME awal

int64_expressionINT64wajib

Jumlah interval yang ditambahkan

datetime_partDATETIME_PARTwajib

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

Contoh Penggunaan

Add Various Intervals

SQL
1SELECT
2  DATETIME '2024-01-15 10:00:00' as original,
3  DATETIME_ADD(DATETIME '2024-01-15 10:00:00', INTERVAL 2 HOUR) as plus_2h,
4  DATETIME_ADD(DATETIME '2024-01-15 10:00:00', INTERVAL 1 DAY) as plus_1d,
5  DATETIME_ADD(DATETIME '2024-01-15 10:00:00', INTERVAL 1 MONTH) as plus_1m;

Menambahkan berbagai interval.

Hasil
originalplus_2hplus_1dplus_1m
2024-01-15T10:00:002024-01-15T12:00:002024-01-16T10:00:002024-02-15T10:00:00

Appointment Scheduling

SQL
1SELECT
2  appointment_id,
3  scheduled_datetime,
4  DATETIME_ADD(scheduled_datetime, INTERVAL 1 HOUR) as end_time,
5  DATETIME_ADD(scheduled_datetime, INTERVAL -15 MINUTE) as reminder_time
6FROM `project.dataset.appointments`;

Kalkulasi end time dan reminder.

Kembali ke BigQuery Functions