Sql server 2012 New date time functions

Sql server 2012 New date time functions

Below are the list of SQL Server 2012 New added functions with examples.

--Passing year month day separately

DATEFROMPARTS ( YEAR,MONTH,DAY )

select DATEFROMPARTS(2014,11,2)


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

select DATETIMEFROMPARTS(2014,11,2,11,30,12,22)



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

select DATETIME2FROMPARTS(2014,11,2,11,30,12,76,4)


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

select SMALLDATETIMEFROMPARTS(2014,11,2,11,3)


DATETIMEOFFSETFROMPARTS ( year, month, day, hour, minute, 
             seconds, fractions, hour_offset, minute_offset, precision )

select DATETIMEOFFSETFROMPARTS(2014,11,2,11,30,12,6,4,2,2)



TIMEFROMPARTS ( hour, minute, seconds, fractions, precision )
select TIMEFROMPARTS(11,12,14,3,3)

--To calculate last date of month 
select EOMONTH (getdate())