dayofyear
Description
Syntax:
INT DAYOFYEAR (DATETIME date)
This function calculates the day of year based on the date.
The parameter is of DATE or DATETIME type.
Example
mysql> select dayofyear('2007-02-03 00:00:00');
+----------------------------------+
| dayofyear('2007-02-03 00:00:00') |
+----------------------------------+
| 34 |
+----------------------------------+Keywords
DAYOFYEAR