DATETIMEFROMPARTS creates a datetime value.
The returned value is based on the specified datepart arguments.
All arguments are required. If any is null, then null is returned.
This example returns a datetime value from the specified dateparts.
SELECT DATETIMEFROMPARTS(2022, 5, 28, 11, 54, 17, 0)
AS Datetime
| Datetime |
|---|
| 2022-05-28 11:54:17.000 |
Syntax of the DATETIMEFROMPARTS function .
DATETIMEFROMPARTS(year, month, day,
hour, minute, seconds, milliseconds)
year -- an integer specifying year.
month -- an integer specifying month.
day -- an integer specifying day of month.
hour -- an integer specifying the hour.
minute -- an integer specifying the minute.
seconds -- an integer specifying the seconds.
milliseconds -- an integer specifying the milliseconds.
Note: DATETIMEFROMPARTS 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.
