This function returns a date value for the specified year, month, and day.
MAKE_DATE ( year, month, day )
An numeric expression that specifies a year.
An numeric expression that specifies a month.
An numeric expression that specifies a day.
Returns the new date as a DATE data type.
- The month and day values may be outside their usual ranges and will be normalized during the conversion.
This example illustrates the using MAKE_DATE on a day value that falls outside its usual range.
SELECT MAKE_DATE(2020, 1, -1);
MAKE_DATE(2020, 1, -1) [DATE]