Edit

dayofyear

description

Syntax

INT DAYOFYEAR(DATETIME date)

DAYOFYEAR function returns the day of the year for a given date.

The parameter is in Date or Datetime type.

example

MySQL > select dayofyear('2007-02-03 00:00:00');
+----------------------------------+
| dayofyear('2007-02-03 00:00:00') |
+----------------------------------+
|                               34 |
+----------------------------------+

keyword

DAYOFYEAR