SQL – MySQL ADDDATE() Function
The MySQL ADDDATE() function adds a time/date interval to a date and then returns the date.
SQL – MySQL ADDTIME() Function
The MySQL ADDTIME() function adds a time interval to a time/datetime and then returns the time/datetime.
SQL – MySQL CURDATE() Function
The MySQL CURDATE() function returns the current date as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
SQL – MySQL CURRENT_DATE() Function
The MySQL CURRENT_DATE() function returns the current date as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
SQL – MySQL CURRENT_TIME() Function
The MySQL CURRENT_TIME() function returns the current time as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
SQL – MySQL CURRENT_TIMESTAMP() Function
The MySQL CURRENT_TIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL CURTIME() Function
The MySQL CURTIME() function returns the current time as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
SQL – MySQL DATE() Function
The MySQL DATE() function extracts the date part from a datetime expression.
SQL – MySQL DATEDIFF() Function
The MySQL DATEDIFF() function returns the number of days between two date values.
SQL – MySQL DATE_ADD() Function
The MySQL DATE_ADD() function adds a time/date interval to a date and then returns the date.
SQL – MySQL DATE_SUB() Function
The MySQL DATE_SUB() function subtracts a time/date interval from a date and then returns the date.
SQL – MySQL DAY() Function
The MySQL DAY() function returns the day of the month for a given date (a number from 1 to 31).
SQL – MySQL DAYNAME() Function
The MySQL DAYNAME() function returns the weekday name for a given date.
SQL – MySQL DAYOFMONTH() Function
The MySQL DAYOFMONTH() function returns the day of the month for a given date (a number from 1 to 31).
SQL – MySQL DAYOFWEEK() Function
The MySQL DAYOFWEEK() function returns the weekday index for a given date (a number from 1 – Sunday to 7 – Saturday).
SQL – MySQL DAYOFYEAR() Function
The MySQL DAYOFYEAR() function returns the day of the year for a given date (a number from 1 to 366).
SQL – MySQL FROM_DAYS() Function
The MySQL FROM_DAYS() function returns a date from a numeric datevalue.
SQL – MySQL HOUR() Function
The MySQL HOUR() function returns the hour part for a given date (from 0 to 838).