MySQL Date/Time makedate() Function

The makedate() is a MySQL date/time function. It is used to make the date of the given year and number of days.

Syntax

Parameter:

Year : 4 digit year to find date

Number_of_days : total number of days, should be greater than zero.

Returns:

This function returns the date for a certain year and day-of-year value.

Example 1

Output:

Example 2

Output: