DAYOFYEAR()

Overview

Returns the day of the year for the given date, in a range of 1 to 366.

See also: Functions in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

EXAMPLES

SELECT DAYOFYEAR('2020-02-29');
+-------------------------+
| DAYOFYEAR('2020-02-29') |
+-------------------------+
|                      60 |
+-------------------------+

Incorrect datetime value

A value is considered "Incorrect datetime value" when it is not a valid or existent datetime value. When SQL_MODE is strict (the default) an Incorrect datetime value generates an error. If strict mode is not in effect, a warning is generated.

SELECT DAYOFYEAR('2019-02-29');
+-------------------------+
| DAYOFYEAR('2019-02-29') |
+-------------------------+
|                    NULL |
+-------------------------+
Warning (Code 1292): Incorrect datetime value: '2019-02-29'

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES