QUARTER
Retrieves the quarter of the year from a given date or datetime
Description
The QUARTER
function extracts and returns the quarter of the year (e.g., 1, 2, 3, 4) from a given date or datetime. This is useful for time-based analysis, organizing data by quarters, or generating quarterly reports.
Syntax
QUARTER(date)
date
: The date or datetime from which you want to extract the quarter.
Example
Table
Statement
Date
Statement A
2023-03-15
Statement B
2023-07-30
Statement C
2023-11-05
Function
QUARTER(`Date`)
Results
QUARTER (integer)
1
3
4
Last updated