Description
This function returns a date value that maps to the specified year, month, and day values.().
Sample Source Pattern
Syntax
DATEFROMPARTS ( year, month, day )
DATE_FROM_PARTS( <year>, <month>, <day> )
Examples
Code:
SELECT DATEFROMPARTS ( 2010, 12, 31 ) AS RESULT;
Result:
RESULT|
----------+
2022-12-12|
Code:
SELECT DATE_FROM_PARTS ( 2010, 12, 31 ) AS RESULT;
Result:
RESULT|
----------+
2022-12-12|