Date & Time

QUARTER

MySQL

Mengembalikan kuartal dari tanggal (1-4). Q1=Jan-Mar, Q2=Apr-Jun, Q3=Jul-Sep, Q4=Oct-Dec.

Tipe hasil: INTEGERDiperbarui: 7 Jan 2026

Syntax

SQL

QUARTER(date)

Parameter

datedatewajib

Tanggal yang akan diambil kuartalnya

Contoh Penggunaan

Ekstrak Kuartal

SQL

1 SELECT QUARTER('2024-08-15') AS qtr;

Agustus masuk Q3.

Hasil

qtr: 3

Laporan Kuartalan

SQL

1 SELECT YEAR(order_date) AS year,
2   QUARTER(order_date) AS quarter,
3   SUM(total) AS revenue
4 FROM orders
5 GROUP BY year, quarter
6 ORDER BY year, quarter;

Agregasi pendapatan per kuartal.

Hasil

(quarterly revenue report)

Filter Q4

SQL

1 SELECT * FROM targets
2 WHERE QUARTER(target_date) = 4
3   AND YEAR(target_date) = YEAR(CURDATE());

Mencari target Q4 tahun ini.

Hasil

(Q4 targets)

Fungsi Equivalen di Database Lain

QUARTER

Snowflake

QUARTER

DuckDB

Fungsi Terkait

EXTRACTYEARMONTHDAYHOURMINUTESECONDWEEK

Kembali ke MySQL Functions

1	SELECT YEAR(order_date) AS year,
2	QUARTER(order_date) AS quarter,
3	SUM(total) AS revenue
4	FROM orders
5	GROUP BY year, quarter
6	ORDER BY year, quarter;

1	SELECT * FROM targets
2	WHERE QUARTER(target_date) = 4
3	AND YEAR(target_date) = YEAR(CURDATE());