QUARTER(date) the range 1 to 4: : QUARTER « Date Time Functions « MySQL Tutorial






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>








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