Pass DAYOFYEAR a date as a string parameter: : DAYOFYEAR « Date Time Functions « MySQL Tutorial






mysql>
mysql> SELECT DAYOFYEAR('2000/02/01');
+-------------------------+
| DAYOFYEAR('2000/02/01') |
+-------------------------+
|                      32 |
+-------------------------+
1 row in set (0.00 sec)

mysql>








14.16.DAYOFYEAR
14.16.1.DAYOFYEAR(date) returns the day of the year for date, in the range 1 to 366.
14.16.2.Pass DAYOFYEAR a date as a string parameter: