DAYOFYEAR

Extracts the day of the year from a date.

Syntax

DAYOFYEAR (dateobj)

Arguments

  • dateobj: a valid date, datetime, or parsable date string.

Return Type

Integer. If dateobj is not a valid date, returns NULL.

Examples

SELECT DAYOFYEAR('2014-04-18');
+-------------------------+
| DAYOFYEAR('2014-04-18') |
+-------------------------+
|                     108 |
+-------------------------+

Last modified: May 31, 2023

Was this article helpful?