Date & Time
MySQL
EXTRACT
MySQLExtracts a specific part from a date or time value (year, month, day, hour, etc.).
Tipe hasil:
INTDiperbarui: 13 Jun 2026Syntax
SQL
EXTRACT(unit FROM date)Parameter
unitkeywordwajib
The part to extract (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, QUARTER, etc.)
dateDATE/DATETIMEwajib
The source date or datetime value
Contoh Penggunaan
Extract Year
SQL
1 SELECT EXTRACT(YEAR FROM '2024-03-15') AS year;
Extracts the year from a date.
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;
Extracts multiple date parts at once.
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);
Aggregates sales data by quarter.
Hasil
(quarterly sales totals)
Pertanyaan Umum tentang EXTRACT
Apa itu fungsi EXTRACT di MySQL?
Extracts a specific part from a date or time value (year, month, day, hour, etc.). Di MySQL, fungsi EXTRACT termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan EXTRACT di MySQL?
Gunakan sintaks berikut: EXTRACT(unit FROM date). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi EXTRACT?
Fungsi EXTRACT mengembalikan nilai bertipe INT. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.
Apa saja parameter fungsi EXTRACT?
Fungsi ini memiliki 2 parameter wajib. Parameter yang digunakan: unit (keyword, wajib): The part to extract (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, QUARTER, etc.); date (DATE/DATETIME, wajib): The source date or datetime value.
Ngulik Langsung
Latihan Langsung →Sudah paham EXTRACT? Latih langsung di browser
Latihan interaktif, langsung di browser.