SQL Server Date Functions
SQL Server date functions and descriptions of their uses.
Download optionsThe records
10 of 13 records ยท Select a column heading to sort.
| ID | Function | Description |
|---|---|---|
| 1 | CURRENT_TIMESTAMP | Returns the current date and time |
| 2 | DATEADD | Adds a time/date interval to a date and then returns the date |
| 3 | DATEDIFF | Returns the difference between two dates |
| 4 | DATEFROMPARTS | Returns a date from the specified parts (year, month, and day values) |
| 5 | DATENAME | Returns a specified part of a date (as string) |
| 6 | DATEPART | Returns a specified part of a date (as integer) |
| 7 | DAY | Returns the day of the month for a specified date |
| 8 | GETDATE | Returns the current database system date and time |
| 9 | GETUTCDATE | Returns the current database system UTC date and time |
| 10 | ISDATE | Checks an expression and returns 1 if it is a valid date, otherwise 0 |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
A complete download includes all 13 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/sqlserverdatefunctionsChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.