DAYOFYEAR(date)

Returns the day of the year for date, in the range 1 to 366. Returns NULL if date is NULL.

Syntax

MYSQL Copy

SELECT DAYOFYEAR('2007-02-03');
34

Examples

Example

MYSQL Copy

SELECT DAYOFYEAR('2007-02-03');
34