QUARTER()
This page is part of MariaDB's SkySQL Documentation.
The parent of this page is: Functions
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).
See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES
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
Release Series | History |
---|---|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
This page shows information specific to MariaDB SkySQL. Information for non-SkySQL use can be found on the QUARTER() page in the MariaDB Enterprise Documentation.