Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Extracts the day of the year from a date.
DAYOFYEAR (dateobj)
Integer. If dateobj is not a valid date, returns NULL.
select dayofyear('2014-04-18');
+-------------------------+
| dayofyear('2014-04-18') |
+-------------------------+
| 108 |
+-------------------------+