DATETIMEFROMPARTS#
Returns a datetime value for the specified date and time.
Syntax#
DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds )
Arguments#
year
Integer expression specifying a year.
month
Integer expression specifying a month.
day
Integer expression specifying a day.
hour
Integer expression specifying hours.
minute
Integer expression specifying minutes.
seconds
Integer expression specifying seconds.
milliseconds
Integer expression specifying milliseconds.
Return types#
datetime
Example#
SELECT DATETIMEFROMPARTS(2016, '3', 10.5, 10, 2, 8.9999, 500);