In this article, we will learn how to use the Date Functions in SQL.
SQL Server has many built-in Date Functions.
| Function | Description |
|---|---|
| CURRENT_TIMESTAMP() | It returns the current date and time.
SELECT CURRENT_TIMESTAMP AS CurrentDateTime; Output: 2019-12-10 12:14:29.110 |
| DATEADD() | It adds a date/time interval to date and then returns the date.
SELECT DATEADD(MONTH, 1, '2019/12/10') AS AddDate; Output: 2020-01-10 00:00:00.000 |
| DATEDIFF() | It returns the difference between two dates.
SELECT DATEDIFF(DAY, '2019/12/10', '2020/01/01') AS DiffDate; Output: 22 |
| DATEFROMPARTS() | It returns a date from the specified parts (year, month, and day).
SELECT DATEFROMPARTS(2019, 12, 10) AS DateFromParts; Output: 2019-12-10 |
| DATENAME() | It returns a specified part of a date in the string.
SELECT DATENAME(MONTH, '2019/12/10') AS DatePartString; Output: December |
| DATEPART() | It returns a specified part of a date in integer.
SELECT DATEPART(MONTH, '2019/12/10') AS DatePartInt; Output: 12 |
| DAY() | It returns the day of the month for a specified date.
SELECT DAY('2019/12/10') AS DayOfMonth;
Output: 10 |
| GETDATE() | It returns the current database system date and time.
SELECT GETDATE() AS CurrentDateTime; Output: 2019-12-10 12:14:29.110 |
| GETUTCDATE() | It returns the current database system UTC date and time.
SELECT GETUTCDATE() AS CurrentUTCDateTime; Output: 2019-12-10 06:55:54.407 |
| ISDATE() | It checks an expression and returns 1 if it is a valid date, otherwise 0.
SELECT ISDATE('2019-12-32');
Output: 0 |
| MONTH() | It returns the month part for a specified date.
SELECT MONTH('2019/12/10') AS Month;
Output: 12 |
| SYSDATETIME() | It returns the date and time of the SQL Server.
SELECT SYSDATETIME() AS CurrentSysDateTime; Output: 2019-12-10 12:28:37.3831871 |
| YEAR() | It returns the year part for a specified date.
SELECT YEAR('2019/12/10') AS Year;
Output: 2019 |
Also, check How To Use NULL Functions In SQL
