MySQL MAKEDATE() Function

Create and return a date based on a year and a number of days value:

SELECT MAKEDATE(2017, 3);

Definition and Usage

The MAKEDATE() function creates and returns a date based on a year and a number of days value.

MAKEDATE( year, day)

Parameter	Description
year	Required. A year (4-digits)
day	Required. A number that indicates the day of the year

Works in:	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);