Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

QUARTER

Extracts the quarter of the year from the given datetime, starting with 1.

Syntax

QUARTER ( dateobj )

Arguments

  • dateobj: a valid date, datetime, or parsable date string.

Return Type

Integer

Examples

select quarter('2009-02-13 23:31:30');
+--------------------------------+
| quarter('2009-02-13 23:31:30') |
+--------------------------------+
|                              1 |
+--------------------------------+