Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. 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>