Date & Time

EXTRACT

MySQL

Mengekstrak bagian tertentu dari tanggal atau waktu (year, month, day, hour, dll).

Tipe hasil: INT

Syntax

SQL

EXTRACT(unit FROM date)

Parameter

unitkeywordwajib

Bagian yang akan diekstrak (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, dll)

dateDATE/DATETIMEwajib

Tanggal atau waktu sumber

Contoh Penggunaan

Extract Year

SQL

1 SELECT EXTRACT(YEAR FROM '2024-03-15') AS year;

Ekstrak tahun dari tanggal.

Hasil

year: 2024

Extract Multiple Parts

SQL

1 SELECT EXTRACT(YEAR FROM order_date) AS year,
2        EXTRACT(MONTH FROM order_date) AS month,
3        EXTRACT(DAY FROM order_date) AS day
4 FROM orders;

Ekstrak beberapa bagian sekaligus.

Hasil

(year, month, day for each order)

Group by Quarter

SQL

1 SELECT EXTRACT(YEAR FROM sale_date) AS year,
2        EXTRACT(QUARTER FROM sale_date) AS quarter,
3        SUM(amount) AS total_sales
4 FROM sales
5 GROUP BY EXTRACT(YEAR FROM sale_date), EXTRACT(QUARTER FROM sale_date);

Agregasi per quarter.

Hasil

(quarterly sales totals)

Fungsi Terkait

YEARMONTHDAYHOURMINUTESECONDQUARTERWEEK

Kembali ke MySQL Functions

1	SELECT EXTRACT(YEAR FROM order_date) AS year,
2	EXTRACT(MONTH FROM order_date) AS month,
3	EXTRACT(DAY FROM order_date) AS day
4	FROM orders;

1	SELECT EXTRACT(YEAR FROM sale_date) AS year,
2	EXTRACT(QUARTER FROM sale_date) AS quarter,
3	SUM(amount) AS total_sales
4	FROM sales
5	GROUP BY EXTRACT(YEAR FROM sale_date), EXTRACT(QUARTER FROM sale_date);