QUARTER()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Returns the quarter of the year for date, in the range 1 to 4. Returns 0 if month contains a zero value, or NULL if the given value is not otherwise a valid date (zero values are accepted).
EXAMPLES
SELECT QUARTER('2020-02-29'),
QUARTER('2020-06-30'),
QUARTER('2019-12-30');
+-----------------------+-----------------------+-----------------------+
| QUARTER('2020-02-29') | QUARTER('2020-06-30') | QUARTER('2019-12-30') |
+-----------------------+-----------------------+-----------------------+
| 1 | 2 | 4 |
+-----------------------+-----------------------+-----------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.