DAYOFYEAR()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the day of the year for the given date, in a range of 1 to 366.
USAGE
DAYOFYEAR(date)
Argument Name | Description |
|---|---|
| The date to evaluate |
DETAILS
DAYOFYEAR() is a date-time function that returns the day of the year in range 1 to 366.
A NULL is returned if the argument is NULL or is not a valid date.
EXAMPLES
SELECT DAYOFYEAR('2020-02-29');
+-------------------------+
| DAYOFYEAR('2020-02-29') |
+-------------------------+
| 60 |
+-------------------------+
ERROR HANDLING
Incorrect datetime value
A value is considered "Incorrect datetime value" when it is not a valid or existent datetime value:
SELECT DAYOFYEAR('2019-02-29');
+-------------------------+
| DAYOFYEAR('2019-02-29') |
+-------------------------+
| NULL |
+-------------------------+