Date & Time

DATE_PART

DuckDB

Mengekstrak komponen tertentu dari date/timestamp. Fungsi alternatif untuk EXTRACT dengan sintaks berbeda.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

DATE_PART(part, date/timestamp)

Parameter

partVARCHARwajib

Nama komponen: 'year', 'month', 'day', 'hour', 'minute', 'second', 'dow', 'doy', 'week', 'quarter'

date/timestampDATE/TIMESTAMPwajib

Nilai tanggal atau timestamp

Contoh Penggunaan

Ekstrak Komponen Tanggal

SQL

1 SELECT
2   DATE_PART('year', order_date) as year,
3   DATE_PART('month', order_date) as month,
4   DATE_PART('day', order_date) as day
5 FROM orders
6 LIMIT 5;

Mengekstrak tahun, bulan, dan hari dari order_date.

Hasil

year	month	day
2024	3	15
2024	3	15
2024	3	14

Analisis per Quarter

SQL

1 SELECT
2   DATE_PART('year', sale_date) as year,
3   DATE_PART('quarter', sale_date) as quarter,
4   SUM(amount) as quarterly_sales
5 FROM sales
6 GROUP BY 1, 2
7 ORDER BY 1, 2;

Menghitung penjualan per kuartal.

Hasil

year	quarter	quarterly_sales
2024	1	500000000
2024	2	620000000

Perbandingan EXTRACT vs DATE_PART

SQL

1 SELECT
2   EXTRACT(MONTH FROM CURRENT_DATE) as extract_month,
3   DATE_PART('month', CURRENT_DATE) as datepart_month;

Kedua fungsi memberikan hasil yang sama.

Hasil

extract_month	datepart_month
3	3.0

Fungsi Terkait

EXTRACTYEARMONTHDAYHOURMINUTESECONDQUARTERWEEK

Kembali ke DuckDB Functions

1	SELECT
2	DATE_PART('year', order_date) as year,
3	DATE_PART('month', order_date) as month,
4	DATE_PART('day', order_date) as day
5	FROM orders
6	LIMIT 5;

1	SELECT
2	DATE_PART('year', sale_date) as year,
3	DATE_PART('quarter', sale_date) as quarter,
4	SUM(amount) as quarterly_sales
5	FROM sales
6	GROUP BY 1, 2
7	ORDER BY 1, 2;

1	SELECT
2	EXTRACT(MONTH FROM CURRENT_DATE) as extract_month,
3	DATE_PART('month', CURRENT_DATE) as datepart_month;