MySQL Tutorial/Date Time Functions/QUARTER

QUARTER(date) returns the quarter of the year for date, in the range 1 to 4.

   <source lang="sql">

mysql> mysql> SELECT QUARTER("99-04-01"); +---------------------+ | QUARTER("99-04-01") | +---------------------+ | 2 | +---------------------+ 1 row in set (0.00 sec) mysql></source>

QUARTER(date) the range 1 to 4:

   <source lang="sql">

mysql> mysql> SELECT QUARTER("01/12/25 11:00:00"); +------------------------------+ | QUARTER("01/12/25 11:00:00") | +------------------------------+ | 4 | +------------------------------+ 1 row in set (0.00 sec) mysql> mysql></source>