Outdated Version
You are viewing an older version of this section. View current production version.
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 |
+--------------------------------+