SMALLDATETIMEFROMPARTS Date Function TSQL Tutorial

SMALLDATETIMEFROMPARTS is an date function and returns a smalldatetime value for the specified date and time.

SMALLDATETIMEFROMPARTS Syntax:

SMALLDATETIMEFROMPARTS( year, month, day, hour, minute )

SMALLDATETIMEFROMPARTS Example:

SELECT SMALLDATETIMEFROMPARTS ( 2014, 03, 01, 15, 50 ) AS Result;

Result
2014-03-01 15:50:00