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

1. MySQL Tutorial
2. Date Time Functions
3. DAYOFYEAR

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

mysql>