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