Date & Time

TIMESTAMPADD

MySQL

Menambahkan interval ke datetime. Return datetime baru setelah penambahan.

Tipe hasil: DATETIMEDiperbarui: 7 Jan 2026

Syntax

SQL

TIMESTAMPADD(unit, interval, datetime)

unitkeywordwajib

Unit interval (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, dll)

intervalINTwajib

Jumlah unit yang ditambahkan (bisa negative)

datetimeDATETIMEwajib

Datetime awal

SQL

1 SELECT TIMESTAMPADD(DAY, 7, '2024-01-15 10:00:00') AS result;

Tambah 7 hari.

Hasil

result: 2024-01-22 10:00:00

SQL

1 SELECT TIMESTAMPADD(HOUR, -3, NOW()) AS three_hours_ago;

3 jam yang lalu.

Hasil

three_hours_ago: (current - 3 hours)

SQL

1 SELECT order_id,
2        TIMESTAMPADD(DAY, delivery_days, order_date) AS due_date
3 FROM orders;

Menghitung tanggal jatuh tempo.

Hasil

(due dates)

TIMESTAMPADD

Snowflake

1	SELECT order_id,
2	TIMESTAMPADD(DAY, delivery_days, order_date) AS due_date
3	FROM orders;