Topic
Syntax:DAYOFYEAR(date)Returns the day of the year for date, in the range 1 to 366.
Example
mysql> SELECT DAYOFYEAR('2007-02-03'); -> 34