Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

MAKEDATE(year,dayofyear) returns a date, given year and day-of-year values

mysql> mysql> SELECT MAKEDATE(2001,31); +-------------------+ | MAKEDATE(2001,31) | +-------------------+ | 2001-01-31        | +-------------------+ 1 row in set (0.00 sec) mysql>