SELECT MAKEDATE(2001,365); : MAKEDATE « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MAKEDATE
mysql>
mysql>
mysql> SELECT MAKEDATE(2001,365);
+--------------------+
| MAKEDATE(2001,365) |
+--------------------+
| 2001-12-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);