Date & Time

DAY

DuckDB

Mengekstrak komponen hari dalam bulan dari tanggal atau timestamp. Mengembalikan angka 1-31.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

DAY(date)

Parameter

dateDATE/TIMESTAMPwajib

Tanggal atau timestamp yang akan diambil hari-nya

Contoh Penggunaan

Mengambil Hari dari Tanggal

SQL

1 SELECT
2   event_date,
3   DAY(event_date) as day_of_month,
4   MONTH(event_date) as month
5 FROM events;

Mengekstrak hari dari tanggal event.

Hasil

event_date	day_of_month	month
2024-06-15	15	6
2024-06-01	1	6
2024-06-30	30	6

Identifikasi Payroll Dates

SQL

1 SELECT *
2 FROM transactions
3 WHERE DAY(transaction_date) IN (25, 26, 27)
4   AND category = 'Salary';

Mencari transaksi gaji yang biasanya di akhir bulan.

Hasil

trans_id	transaction_date	category	amount
1001	2024-06-25	Salary	15000000
1002	2024-05-25	Salary	15000000

Analisis Pola Tanggal

SQL

1 SELECT
2   DAY(order_date) as day_of_month,
3   COUNT(*) as order_count,
4   AVG(amount) as avg_order_value
5 FROM orders
6 GROUP BY DAY(order_date)
7 ORDER BY order_count DESC
8 LIMIT 5;

Menemukan tanggal dalam bulan dengan order terbanyak.

Hasil

day_of_month	order_count	avg_order_value
1	1250	450000
15	1180	520000
25	1150	680000

Fungsi Terkait

EXTRACTDATE_PARTYEARMONTHHOURMINUTESECONDQUARTERWEEK

Kembali ke DuckDB Functions

1	SELECT
2	event_date,
3	DAY(event_date) as day_of_month,
4	MONTH(event_date) as month
5	FROM events;

1	SELECT *
2	FROM transactions
3	WHERE DAY(transaction_date) IN (25, 26, 27)
4	AND category = 'Salary';

1	SELECT
2	DAY(order_date) as day_of_month,
3	COUNT(*) as order_count,
4	AVG(amount) as avg_order_value
5	FROM orders
6	GROUP BY DAY(order_date)
7	ORDER BY order_count DESC
8	LIMIT 5;