There are four functions for converting a date to a day number:
DAYOFYEAR(date)
DAYOFMONTH(date)
DAYOFWEEK(date)
WEEKDAY(date)
DAYOFYEAR(date) returns the day of the year for a given date (in numeric format).
DAYOFYEAR(date) returns how many days since January 1 of that year.
mysql> mysql> SELECT DAYOFYEAR(20000201); +---------------------+ | DAYOFYEAR(20000201) | +---------------------+ | 32 | +---------------------+ 1 row in set (0.01 sec)
14.1.Introduction | ||||
14.1.1. | Date and Time Functions | |||
14.1.2. | Extraction Functions | |||
14.1.3. | Changing Date Values | |||
14.1.4. | Getting Day Information | |||
14.1.5. | Getting Names for Months and Days | |||
14.1.6. | Extracting Years, Quarters, Months, and Weeks | |||
14.1.7. | Current Date and Time | |||
14.1.8. | Days Since 1 A.D. | |||
14.1.9. | Seconds Since the Beginning of the Day |