Date & Time

DATE_PART

PostgreSQL

Mengekstrak bagian tertentu dari tanggal atau timestamp. Sama dengan EXTRACT tapi dengan sintaks berbeda. Mengembalikan double precision.

Tipe hasil: double precision

Syntax

SQL

DATE_PART(field, source)

Parameter

fieldtextwajib

Bagian yang diekstrak: year, month, day, hour, minute, second, dow, doy, week, quarter, epoch

sourcetimestamp/intervalwajib

Tanggal atau interval sumber

Contoh Penggunaan

Ekstrak Komponen Tanggal

SQL

1 SELECT 
2   DATE_PART(year, TIMESTAMP 2024-06-15 14:30:00) AS year,
3   DATE_PART(month, TIMESTAMP 2024-06-15 14:30:00) AS month,
4   DATE_PART(day, TIMESTAMP 2024-06-15 14:30:00) AS day;

Mengekstrak tahun, bulan, dan hari.

Hasil

year	month	day
2024	6	15

Day of Week dan Day of Year

SQL

1 SELECT 
2   DATE_PART(dow, CURRENT_DATE) AS day_of_week,
3   DATE_PART(doy, CURRENT_DATE) AS day_of_year;

dow: 0=Sunday, 6=Saturday. doy: 1-366.

Hasil

day_of_week	day_of_year
1	15

Group by Quarter

SQL

1 SELECT 
2   DATE_PART(quarter, order_date) AS quarter,
3   SUM(total) AS revenue
4 FROM orders
5 WHERE DATE_PART(year, order_date) = 2024
6 GROUP BY quarter;

Menghitung revenue per quarter.

Fungsi Equivalen di Database Lain

DATE_PART

Snowflake

DATE_PART

DuckDB

Fungsi Terkait

EXTRACT

Kembali ke PostgreSQL Functions

1	SELECT
2	DATE_PART(year, TIMESTAMP 2024-06-15 14:30:00) AS year,
3	DATE_PART(month, TIMESTAMP 2024-06-15 14:30:00) AS month,
4	DATE_PART(day, TIMESTAMP 2024-06-15 14:30:00) AS day;

1	SELECT
2	DATE_PART(dow, CURRENT_DATE) AS day_of_week,
3	DATE_PART(doy, CURRENT_DATE) AS day_of_year;

1	SELECT
2	DATE_PART(quarter, order_date) AS quarter,
3	SUM(total) AS revenue
4	FROM orders
5	WHERE DATE_PART(year, order_date) = 2024
6	GROUP BY quarter;