DATEFROMPARTS

Applies to

Description

This function returns a date value that maps to the specified year, month, and day values.().

DATEFROMPARTS ( year, month, day )

DATE_FROM_PARTS( <year>, <month>, <day> )

Code:

IN -> SqlServer_01.sql

SELECT DATEFROMPARTS ( 2010, 12, 31 ) AS RESULT;

Result:

    RESULT|
----------+
2022-12-12|

Code:

OUT -> SqlServer_01.sql

SELECT DATE_FROM_PARTS ( 2010, 12, 31 ) AS RESULT;

Result:

    RESULT|
----------+
2022-12-12|

No issues were found.

No related EWIs.

Last updated 3 months ago