Outdated Version
You are viewing an older version of this section. View current production version.
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 |
+-------------------------+
