MAKEDATE « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. MAKEDATE
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);