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