select MAKEDATE(2001,32); : MAKEDATE « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MAKEDATE
mysql>
mysql>
mysql> select MAKEDATE(2001,32);
+-------------------+
| MAKEDATE(2001,32) |
+-------------------+
| 2001-02-01        |
+-------------------+
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);