Skip to main content

MAKE_DATE

This function returns a date value for the specified year, month, and day.

Syntax

MAKE_DATE ( year, month, day ) 

Arguments

year
An numeric expression that specifies a year.

month
An numeric expression that specifies a month.

day
An numeric expression that specifies a day.

Return Value

Returns the new date as a DATE data type.

Remarks

  • The month and day values may be outside their usual ranges and will be normalized during the conversion.

Examples

This example illustrates the using MAKE_DATE on a day value that falls outside its usual range.

SELECT MAKE_DATE(2020, 1, -1);

Response:

MAKE_DATE(2020, 1, -1) [DATE]
2019-12-31