SQL Server 2012 Date and Time Functions

Hi All.  I’ve put together an alphabetical reference list for SQL Server 2012 Date and Time Functions which may come in handy when you’ve forgotten a particular keyword or just want to see what is available in one place without referencing books online.  There are 26 items in the list.

@@DATEFIRST
CURRENT_TIMESTAMP
DATEADD
DATEDIFF
DATEFROMPARTS
DATENAME
DATEPART
DATETIME2FROMPARTS
DATETIMEFROMPARTS
DATETIMEOFFSETFROMPARTS
DAY
EOMONTH
GETDATE
GETUTCDATE
ISDATE
MONTH
SET DATEFIRST
SET DATEFORMAT
SMALLDATETIMEFROMPARTS
SWITCHOFFSET
SYSDATETIME
SYSDATETIMEOFFSET
SYSUTCDATETIME
TIMEFROMPARTS
TODATETIMEOFFSET
YEAR