Microsoft SQL Server Date Function | Notes |
CURRENT_DATE | |
CURRENT_TIMESTAMP | |
DATEADD | SQL Server 2014 only. |
DATEDIFF | SQL Server 2008, 2012, 2014. DATEDIFF (DATEPART, STARTDATE, ENDDATE) |
DATEPART | SQL Server 2014 only. |
DAY | |
DAYNAME | SQL Server 2014 only. |
DAYOFMONTH | SQL Server 2014 only. |
DAYOFWEEK | SQL Server 2014 only. |
HOUR | SQL Server 2014 only. |
MINUTE | SQL Server 2014 only. |
MONTH | |
MONTHNAME | SQL Server 2014 only. |
QUARTER | SQL Server 2014 only. |
SECOND | SQL Server 2014 only. |
WEEK | SQL Server 2014 only. |
YEAR |