Date & Time

DATE_PART

Snowflake

Mengekstrak komponen tertentu dari date atau timestamp. Equivalent dengan EXTRACT.

Tipe hasil: NUMBERDiperbarui: 6 Jan 2026

Syntax

SQL

DATE_PART(part, date_or_time)

Parameter

partstring literalwajib

Komponen: year, month, day, hour, minute, second, quarter, week, dayofweek, dst

date_or_timeDATE/TIME/TIMESTAMPwajib

Nilai tanggal atau waktu

Contoh Penggunaan

Extract Date Parts

SQL

1 SELECT
2   DATE_PART('year', '2024-03-15'::DATE) as year,
3   DATE_PART('month', '2024-03-15'::DATE) as month,
4   DATE_PART('day', '2024-03-15'::DATE) as day;

Mengekstrak komponen dari tanggal.

Hasil

YEAR	MONTH	DAY
2024	3	15

Extract Time Parts

SQL

1 SELECT
2   DATE_PART('hour', CURRENT_TIMESTAMP) as hour,
3   DATE_PART('minute', CURRENT_TIMESTAMP) as minute;

Mengekstrak jam dan menit.

Group by Quarter

SQL

1 SELECT
2   DATE_PART('year', order_date) as year,
3   DATE_PART('quarter', order_date) as quarter,
4   SUM(amount) as total
5 FROM orders
6 GROUP BY 1, 2
7 ORDER BY 1, 2;

Agregasi per quarter.

Fungsi Terkait

EXTRACTYEARMONTHDAYHOURMINUTESECONDQUARTERWEEK

Kembali ke Snowflake Functions

1	SELECT
2	DATE_PART('year', '2024-03-15'::DATE) as year,
3	DATE_PART('month', '2024-03-15'::DATE) as month,
4	DATE_PART('day', '2024-03-15'::DATE) as day;

1	SELECT
2	DATE_PART('hour', CURRENT_TIMESTAMP) as hour,
3	DATE_PART('minute', CURRENT_TIMESTAMP) as minute;

1	SELECT
2	DATE_PART('year', order_date) as year,
3	DATE_PART('quarter', order_date) as quarter,
4	SUM(amount) as total
5	FROM orders
6	GROUP BY 1, 2
7	ORDER BY 1, 2;