MySQL Date Functions
MySQL date functions and descriptions of their uses.
Download optionsThe records
10 of 50 records ยท Select a column heading to sort.
| ID | Function | Description |
|---|---|---|
| 1 | ADDDATE | Adds a time/date interval to a date and then returns the date |
| 2 | ADDTIME | Adds a time interval to a time/datetime and then returns the time/datetime |
| 3 | CURDATE | Returns the current date |
| 4 | CURRENT_DATE | Returns the current date |
| 5 | CURRENT_TIME | Returns the current time |
| 6 | CURRENT_TIMESTAMP | Returns the current date and time |
| 7 | CURTIME | Returns the current time |
| 8 | DATE | Extracts the date part from a datetime expression |
| 9 | DATEDIFF | Returns the number of days between two date values |
| 10 | DATE_ADD | Adds a time/date interval to a date and then returns the date |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
No source links are listed for this dataset. Ask about its coverage before using it where accuracy or recency matters.
A complete download includes all 50 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/mysqldatefunctionsChoose 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.