Name

MAKEDATE()

Synopsis

MAKEDATE(year, dayofyear)

Returns the date for the given year and dayofyear values. If dayofyear is zero, the result is NULL. This code returns the date “2016-09-30”:

SELECT MAKEDATE(2016,274);