SQL Server provides several date functions that allow you to work with date and time values. These functions help you retrieve, manipulate, and format dates and times in various ways. Here are some commonly used SQL Server date functions:
Returning the current date and time
| Function | Description |
| CURREMT TIMESTAMP | Returns the current system date and time without the time zone part |
| GETUTCDATE | Returns date and UTC Time |
| GETDATE | Return the current system date and time of the operating system |
| SYSDATETIME | Return 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 current 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 specified 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 | Return a DATETIME2 value from the date and time arguments |
| DATETIMEOFFSETFROMPARTS | Return 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 |
These are just a few examples of the date functions available in SQL Server. Each function has specific syntax and usage requirements, which can be found in the SQL Server documentation for the corresponding version of the software.