MAKEDATE

Create and return a date using a specified year and a day-of-year value.

SELECT MAKEDATE(2017, 3);

Definition and Usage

The MAKEDATE() function constructs and returns a date using a specified year and a day-of-year value.

MAKEDATE(year, day)

Parameter	Description
year	Mandatory: A four-digit year
date	Mandatory: A numeric value representing the day of the year

Works in:

From MySQL version 4.0

Construct and return a date using a specified year and a day-of-year value.

SELECT MAKEDATE(2017, 175);

Generate and return a date using a given year and a specific day-of-year value.

SELECT MAKEDATE(2017, 100);

Formulate and provide a date using a specified year and a day count value.

SELECT MAKEDATE(2017, 366);