Loading lesson path
Concept visual
Start at both ends
Create and return a date based on a year and a number of days value:
SELECT MAKEDATE(2017, 3);The MAKEDATE() function creates and returns a date based on a year and a number of days value.
year, day )
Formula
Required. A year (4 - digits)day Required. A number that indicates the day of the year
From MySQL 4.0
Create and return a date based on a year and a number of days value:
SELECT MAKEDATE(2017, 175);Create and return a date based on a year and a number of days value:
SELECT MAKEDATE(2017, 100);Create and return a date based on a year and a number of days value:
SELECT MAKEDATE(2017, 366);❮ MySQL Functions