Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

QUARTER(date) the range 1 to 4

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>