Creating Date, DateTime, Time objects with FROMPARTS functions.

   

    SQL Server 2012 introduced a new way to create Date, DateTime, DateTime2, DateTimeOffset, SmallDateTime, and Time objects. All functions are available in Azure SQL Database, Azure SQL Data Warehouse and Parallel Data Warehouse as well.  Here is the list of DateFrom functions and examples. 

DATETIMEFROMPARTS

DATETIMEFROMPARTS (year, month, day, hour, minute, seconds, milliseconds)

DATEFROMPARTS

DATEFROMPARTS (year, month, day)

DATETIME2FROMPARTS

DATETIME2FROMPARTS (year, month, day, hour, minute, seconds, fractions, precision)

DATETIMEOFFSETFROMPARTS

DATETIMEOFFSETFROMPARTS (year,month,day,hour,minute,seconds,fraction,hr_offset,min_ offset, precision)

SMALLDATETIMEFROMPARTS

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

TIMEFROMPARTS

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