Date & Time

DATE_ADD

BigQuery

Menambahkan interval waktu tertentu ke DATE. Mengembalikan DATE baru.

Tipe hasil: DATEDiperbarui: 7 Jan 2026

Syntax

SQL

DATE_ADD(date_expression, INTERVAL int64_expression date_part)

Parameter

date_expressionDATEwajib

DATE awal

int64_expressionINT64wajib

Jumlah interval yang ditambahkan

date_partDATE_PARTwajib

Unit interval: DAY, WEEK, MONTH, QUARTER, YEAR

Contoh Penggunaan

Add Days

SQL

1 SELECT
2   DATE '2024-01-15' as original,
3   DATE_ADD(DATE '2024-01-15', INTERVAL 7 DAY) as plus_week,
4   DATE_ADD(DATE '2024-01-15', INTERVAL 1 MONTH) as plus_month,
5   DATE_ADD(DATE '2024-01-15', INTERVAL 1 YEAR) as plus_year;

Menambahkan berbagai interval ke tanggal.

Hasil

original	plus_week	plus_month	plus_year
2024-01-15	2024-01-22	2024-02-15	2025-01-15

Calculate Due Date

SQL

1 SELECT
2   order_id,
3   order_date,
4   DATE_ADD(order_date, INTERVAL 30 DAY) as payment_due
5 FROM `project.dataset.orders`;

Hitung tanggal jatuh tempo pembayaran.

End of Month Handling

SQL

1 SELECT
2   DATE '2024-01-31' as jan_31,
3   DATE_ADD(DATE '2024-01-31', INTERVAL 1 MONTH) as feb_result;

BigQuery menangani end-of-month dengan benar.

Hasil

jan_31	feb_result
2024-01-31	2024-02-29

Fungsi Terkait

DATE_SUBDATE_DIFF

Kembali ke BigQuery Functions

1	SELECT
2	DATE '2024-01-15' as original,
3	DATE_ADD(DATE '2024-01-15', INTERVAL 7 DAY) as plus_week,
4	DATE_ADD(DATE '2024-01-15', INTERVAL 1 MONTH) as plus_month,
5	DATE_ADD(DATE '2024-01-15', INTERVAL 1 YEAR) as plus_year;

1	SELECT
2	order_id,
3	order_date,
4	DATE_ADD(order_date, INTERVAL 30 DAY) as payment_due
5	FROM `project.dataset.orders`;

1	SELECT
2	DATE '2024-01-31' as jan_31,
3	DATE_ADD(DATE '2024-01-31', INTERVAL 1 MONTH) as feb_result;