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 |
+--------------------------------+