SQL DATEFROMPARTS Function

DATEFROMPARTS returns the date from the dateparts.

The specified dateparts include year, month, and day.

All three parameters are required.

Example

#

This example returns a date from the year, month, and day dateparts.

SELECT DATEFROMPARTS(2021, 9, 28) AS 'Returned Date'
Result:  1 record
Returned Date
2021-09-28

Syntax

Syntax of the DATEFROMPARTS function.

DATEFROMPARTS(year, month, day) 

year -- an integer specifying year (4 digits).

month -- an integer specifying month (1 - 12).

day -- an integer specifying day of month (1 - 31).

Note: DATEFROMPARTS will return an error if any of the arguments is invalid. If any of the arguments is null, then the return value will also be null.


You may also like



Guides


vsn 3.1