Date & Time

DATETIME_ADD

Q: Apa saja parameter fungsi DATETIME_ADD?

Fungsi ini memiliki 3 parameter wajib. Parameter yang digunakan: datetime_expression (DATETIME, wajib): The starting DATETIME value; int64_expression (INT64, wajib): The number of intervals to add; datetime_part (DATETIME_PART, wajib): Interval unit: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, etc..

BigQuery

Adds a time interval to a DATETIME value. Supports all units from MICROSECOND to YEAR.

Tipe hasil: DATETIMEDiperbarui: 13 Jun 2026

Syntax

SQL

DATETIME_ADD(datetime_expression, INTERVAL int64_expression datetime_part)

Parameter

datetime_expressionDATETIMEwajib

The starting DATETIME value

int64_expressionINT64wajib

The number of intervals to add

datetime_partDATETIME_PARTwajib

Interval unit: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, etc.

Contoh Penggunaan

Add Various Intervals

SQL

1 SELECT
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;

Add various intervals to a datetime value.

Hasil

original	plus_2h	plus_1d	plus_1m
2024-01-15T10:00:00	2024-01-15T12:00:00	2024-01-16T10:00:00	2024-02-15T10:00:00

Appointment Scheduling

SQL

1 SELECT
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
6 FROM `project.dataset.appointments`;

Calculate the end time and reminder time for appointments.

Pertanyaan Umum tentang DATETIME_ADD

Apa itu fungsi DATETIME_ADD di BigQuery?

Adds a time interval to a DATETIME value. Supports all units from MICROSECOND to YEAR. Di BigQuery, fungsi DATETIME_ADD termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan DATETIME_ADD di BigQuery?

Gunakan sintaks berikut: DATETIME_ADD(datetime_expression, INTERVAL int64_expression datetime_part). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi DATETIME_ADD?

Fungsi DATETIME_ADD mengembalikan nilai bertipe DATETIME. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda - selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Ngulik Langsung

Sudah paham DATETIME_ADD? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
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;

1	SELECT
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
6	FROM `project.dataset.appointments`;