Date & Time

DATE_SUB

DuckDB

Mengurangi interval waktu dari sebuah tanggal atau timestamp. Kebalikan dari DATE_ADD.

Tipe hasil: DATE/TIMESTAMP (sesuai input)Diperbarui: 6 Jan 2026

Syntax

SQL

DATE_SUB(date, interval) | date - INTERVAL 'n unit'

Parameter

dateDATE/TIMESTAMPwajib

Tanggal atau timestamp awal

intervalINTERVALwajib

Interval yang dikurangi

Contoh Penggunaan

Mengurangi Hari

SQL

1 SELECT
2   CURRENT_DATE as today,
3   CURRENT_DATE - INTERVAL '7 days' as last_week,
4   CURRENT_DATE - INTERVAL '30 days' as last_month;

Menghitung tanggal 7 hari dan 30 hari yang lalu.

Hasil

today	last_week	last_month
2024-03-15	2024-03-08	2024-02-14

Filter Data 7 Hari Terakhir

SQL

1 SELECT *
2 FROM orders
3 WHERE order_date >= CURRENT_DATE - INTERVAL '7 days';

Mengambil order dalam 7 hari terakhir.

Periode Bulan Lalu

SQL

1 SELECT
2   COUNT(*) as total_orders,
3   SUM(amount) as total_revenue
4 FROM orders
5 WHERE order_date >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month'
6   AND order_date < DATE_TRUNC('month', CURRENT_DATE);

Menghitung statistik bulan lalu secara lengkap.

Data N Hari Terakhir

SQL

1 SELECT
2   order_date,
3   COUNT(*) as daily_orders
4 FROM orders
5 WHERE order_date >= CURRENT_DATE - INTERVAL '14 days'
6 GROUP BY order_date
7 ORDER BY order_date;

Mengambil trend order 14 hari terakhir.

Fungsi Terkait

DATE_ADDAGEDATE_DIFF

Kembali ke DuckDB Functions

1	SELECT
2	CURRENT_DATE as today,
3	CURRENT_DATE - INTERVAL '7 days' as last_week,
4	CURRENT_DATE - INTERVAL '30 days' as last_month;

1	SELECT *
2	FROM orders
3	WHERE order_date >= CURRENT_DATE - INTERVAL '7 days';

1	SELECT
2	COUNT(*) as total_orders,
3	SUM(amount) as total_revenue
4	FROM orders
5	WHERE order_date >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month'
6	AND order_date < DATE_TRUNC('month', CURRENT_DATE);

1	SELECT
2	order_date,
3	COUNT(*) as daily_orders
4	FROM orders
5	WHERE order_date >= CURRENT_DATE - INTERVAL '14 days'
6	GROUP BY order_date
7	ORDER BY order_date;