SMALLDATETIMEFROMPARTS
Returns a smalldatetime value for the specified date and time.
Syntax
SMALLDATETIMEFROMPARTS ( year, month, day, hour, minute )
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.
Return types
smalldatetime
Example
SELECT SMALLDATETIMEFROMPARTS(2010,12,31,23,59);