SQL Function Reference

MAKEDATE

Returns a date value constructed from the year and day of year.

MySQL

MAKEDATE(year, dayofyear)

year

The year.

dayofyear

The day of the year (1-366).

Examples

MySQL

SELECT MAKEDATE(2025, 156);

MySQL

SELECT MAKEDATE(YEAR(date), DAYOFYEAR(date))
FROM Payments;