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 | +-------------------------+