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