TIMEFROMPARTS function – SQL Server Denali

We are going to discuss another new function that’s going to get released with SQL Server Denali. This function is related to date time category. This is similar to the early function which we saw. Time returns a fully initialized time value. If the arguments are invalid then an error is raised, if you have NULL value in argument then NULL is returned.

Syntax is below

TIMEFROMPARTS ( hour, minute, seconds, fractions, precision )

Lets try with an example

SELECT TIMEFROMPARTS(21,53,33,55,3)