This page lists the most commonly used SQL Server Date functions that allow you to handle date and time data effectively.
Returning the current date and time #
| Function | Description |
|---|---|
| CURRENT_TIMESTAMP | Returns the current system date and time without the time zone part. |
| GETUTCDATE | Returns a date part of a date as an integer number. |
| GETDATE | Returns the current system date and time of the operating system on which the SQL Server is running. |
| SYSDATETIME | Returns the current system date and time with more fractional seconds precision than the GETDATE() function. |
| SYSUTCDATETIME | Returns the current system date and time in UTC time |
| SYSDATETIMEOFFSET | Returns the current system date and time with the time zone. |
Returning the date and time Parts #
| Function | Description |
|---|---|
| DATENAME | Returns a date part of a date as a character string |
| DATEPART | Returns a date part of a date as an integer number |
| DAY | Returns the day of a specified date as an integer |
| MONTH | Returns the month of a specified date as an integer |
| YEAR | Returns the year of the date as an integer. |
Returning a difference between two dates #
| Function | Return value |
|---|---|
| DATEDIFF | Returns a difference in date part between two dates. |
Modifying dates #
| Function | Description |
|---|---|
| DATEADD | Adds a value to a date part of a date and return the new date value. |
| EOMONTH | Returns the last day of the month containing the specified date, with an optional offset. |
| SWITCHOFFSET | Changes the time zone offset of a DATETIMEOFFSET value and preserves the UTC value. |
| TODATETIMEOFFSET | Transforms a DATETIME2 value into a DATETIMEOFFSET value. |
Constructing date and time from their parts #
| Function | Description |
|---|---|
| DATEFROMPARTS | Return a DATE value from the year, month, and day. |
| DATETIME2FROMPARTS | Returns a DATETIME2 value from the date and time arguments |
| DATETIMEOFFSETFROMPARTS | Returns a DATETIMEOFFSET value from the date and time arguments |
| TIMEFROMPARTS | Returns a TIME value from the time parts with the precisions |
Validating date and time values #
| Function | Description |
|---|---|
| ISDATE | Check if a value is a valid date, time, or datetime value |
