SQL Extract Quarter

Returns which quarter of the year a date falls in — 1 through 4, three months each.

What & Why

EXTRACT(QUARTER FROM date_column) returns a number from 1 to 4: Q1 is January-March, Q2 is April-June, Q3 is July-September, Q4 is October-December. Common for financial and business reporting that groups by fiscal quarter.

See How It Works

BUSINESS QUESTION

Marketing wants campaign counts by quarter.

id	name	channel	spend	start_date	end_date	status	target_segment
1	Spring Launch	google_ads	55000.00	2024-01-15	2024-03-31	active	smb
2	Retention Webinar	email	45000.00	2024-02-10	2024-04-15	active	enterprise
3	Finance Retargeting	linkedin	50000.00	2024-03-12	2024-05-31	active	enterprise
4	Enterprise Search	google_ads	60000.00	2024-04-01	2024-06-30	active	enterprise

EXAMPLE QUERY

SELECT
  EXTRACT(QUARTER FROM start_date)::int AS start_quarter,
  COUNT(*) AS campaign_count
FROM marketing.campaigns
GROUP BY start_quarter
ORDER BY start_quarter;

RESULT — exact output from the displayed Queryflo rows

start_quarter	campaign_count
1	3
2	1

January through March form Q1; the April campaign begins Q2.

Now You Try

Practice this concept

Marketing wants campaign counts by quarter.

Available schema

marketing

Prefix tables with marketing.table_name.

start_quartercampaign_count

marketing.campaigns

Column	Type
id	integer
name	text
channel	text
spend	numeric
start_date	date
end_date	date
status	text
target_segment	text
legacy_id	text

query.sql

Intermediate business practice