Date & Time

QUARTER

Snowflake

Mengekstrak quarter (kuartal) dari date atau timestamp.

Tipe hasil: NUMBERDiperbarui: 6 Jan 2026

Syntax

SQL

QUARTER(date_or_timestamp)

date_or_timestampDATE/TIMESTAMPwajib

Nilai tanggal atau timestamp

SQL

1 SELECT QUARTER('2024-03-15'::DATE) as q;

Maret adalah Q1.

Hasil

SQL

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

Laporan per kuartal.

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