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);

See Also#