Name

DAYOFYEAR()

Synopsis

DAYOFYEAR(date)

Returns the day of the year for date, in the range 1 to 366. This code returns the value 34:

SELECT DAYOFYEAR('2016-02-03');