| Name |
Description |
| ADDDATE() |
Add dates |
| ADDTIME() |
Add time |
| CONVERT_TZ() |
Convert from one timezone to another |
| CURDATE() |
Return the current date |
| CURRENT_DATE(), CURRENT_DATE |
Synonyms for CURDATE() |
| CURRENT_TIME(), CURRENT_TIME |
Synonyms for CURTIME() |
| CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP |
Synonyms for NOW() |
| CURTIME() |
Return the current time |
| DATE_ADD() |
Add two dates |
| DATE_FORMAT() |
Format date as specified |
| DATE_SUB() |
Subtract two dates |
| DATE() |
Extract the date part of a date or datetime expression |
| DATEDIFF() |
Subtract two dates |
| DAY() |
Synonym for DAYOFMONTH() |
| DAYNAME() |
Return the name of the weekday |
| DAYOFMONTH() |
Return the day of the month (1-31) |
| DAYOFWEEK() |
Return the weekday index of the argument |
| DAYOFYEAR() |
Return the day of the year (1-366) |
| EXTRACT |
Extract part of a date |
| FROM_DAYS() |
Convert a day number to a date |
| FROM_UNIXTIME() |
Format date as a UNIX timestamp |
| GET_FORMAT() |
Return a date format string |
| HOUR() |
Extract the hour |
| LAST_DAY |
Return the last day of the month for the argument |
| LOCALTIME(), LOCALTIME |
Synonym for NOW() |
| LOCALTIMESTAMP, LOCALTIMESTAMP() |
Synonym for NOW() |
| MAKEDATE() |
Create a date from the year and day of year |
| MAKETIME |
returns a time value calculated from the hour, minute, and second arguments |
| MICROSECOND() |
Return the microseconds from argument |
| MINUTE() |
Return the minute from the argument |
| MONTH() |
Return the month from the date passed |
| MONTHNAME() |
Return the name of the month |
| NOW() |
Return the current date and time |
| PERIOD_ADD() |
Add a period to a year-month |
| PERIOD_DIFF() |
Return the number of months between periods |
| QUARTER() |
Return the quarter from a date argument |
| SEC_TO_TIME() |
Converts seconds to 'HH:MM:SS' format |
| SECOND() |
Return the second (0-59) |
| STR_TO_DATE() |
Convert a string to a date |
| SUBDATE() |
When invoked with three arguments a synonym for DATE_SUB() |
| SUBTIME() |
Subtract times |
| SYSDATE() |
Return the time at which the function executes |
| TIME_FORMAT() |
Format as time |
| TIME_TO_SEC() |
Return the argument converted to seconds |
| TIME() |
Extract the time portion of the expression passed |
| TIMEDIFF() |
Subtract time |
| TIMESTAMP() |
With a single argument, this function returns the date or datetime expression. With two arguments, the sum of the arguments |
| TIMESTAMPADD() |
Add an interval to a datetime expression |
| TIMESTAMPDIFF() |
Subtract an interval from a datetime expression |
| TO_DAYS() |
Return the date argument converted to days |
| UNIX_TIMESTAMP() |
Return a UNIX timestamp |
| UTC_DATE() |
Return the current UTC date |
| UTC_TIME() |
Return the current UTC time |
| UTC_TIMESTAMP() |
Return the current UTC date and time |
| WEEK() |
Return the week number |
| WEEKDAY() |
Return the weekday index |
| WEEKOFYEAR() |
Return the calendar week of the date (1-53) |
| YEAR() |
Return the year |
| YEARWEEK() |
Return the year and week |
