MySafeInfo

MySQL Date Functions

Technology 50 records updated 2026-07-17

MySQL Date Functions, with function, and description.

Get this data

GET https://mysafeinfo.com/api/data/mysqldatefunctions

JSON XML CSV Download CSV

Sort, page, randomize, and download with query parameters; see the documentation.

Try it live

Run a request against mysqldatefunctions straight from your browser. Add your API key to lift the row cap and return every record. The call goes to the API and nothing is stored here.

Preview

First 25 of 50 records. Click a column to sort these rows.

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
11 DATE_FORMAT Formats a date
12 DATE_SUB Subtracts a time/date interval from a date and then returns the date
13 DAY Returns the day of the month for a given date
14 DAYNAME Returns the weekday name for a given date
15 DAYOFMONTH Returns the day of the month for a given date
16 DAYOFWEEK Returns the weekday index for a given date
17 DAYOFYEAR Returns the day of the year for a given date
18 EXTRACT Extracts a part from a given date
19 FROM_DAYS Returns a date from a numeric datevalue
20 HOUR Returns the hour part for a given date
21 LAST_DAY Extracts the last day of the month for a given date
22 LOCALTIME Returns the current date and time
23 LOCALTIMESTAMP Returns the current date and time
24 MAKEDATE Creates and returns a date based on a year and a number of days value
25 MAKETIME Creates and returns a time based on an hour, minute, and second value

Notes

Related datasets

More in Technology:

Browse all datasets