MAKEDATE(year,dayofyear) returns a date, given year and day-of-year values. : MAKEDATE « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MAKEDATE
mysql>
mysql> SELECT MAKEDATE(2001,31);
+-------------------+
| MAKEDATE(2001,31) |
+-------------------+
| 2001-01-31        |
+-------------------+
1 row in set (0.00 sec)

mysql>








14.26.MAKEDATE
14.26.1.MAKEDATE(year,dayofyear) returns a date, given year and day-of-year values.
14.26.2.select MAKEDATE(2001,32);
14.26.3.SELECT MAKEDATE(2001,365);
14.26.4.select MAKEDATE(2004,365);
14.26.5.SELECT MAKEDATE(2001,0);