MySQL in a Nutshell, 2nd Edition

Date and Time Functions Grouped by Type

Following are lists of date and time functions, grouped according to their purpose: to retrieve the date or time, to extract an element from a given date or time, or to perform calculations on given dates or times.

Determining the Date or Time

CURDATE(), CURRENT_DATE(), CURRENT_TIME(), CURRENT_TIMESTAMP(), CURTIME(), LOCALTIME(), LOCALTIMESTAMP(), NOW(), SYSDATE(), UNIX_TIMESTAMP(), UTC_DATE(), UTC_TIME(), UTC_TIMESTAMP().

Extracting and Formatting the Date or Time

DATE(), DATE_FORMAT(), DAY(), DAYNAME(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), EXTRACT(), GET_FORMAT(), HOUR(), LAST_DAY(), MAKEDATE(), MAKETIME(), MICROSECOND(), MINUTE(), MONTH(), MONTHNAME(), QUARTER(), SECOND(), STR_TO_DATE(), TIME(), TIME_FORMAT(), TIMESTAMP(), WEEK(), WEEKDAY(), WEEKOFYEAR(), YEAR(), YEARWEEK().

Calculating and Modifying the Date or Time

ADDDATE(), ADDTIME(), CONVERT_TZ(), DATE_ADD(), DATE_SUB(), DATEDIFF(), FROM_DAYS(), FROM_UNIXTIME(), PERIOD_ADD(), PERIOD_DIFF(), SEC_TO_TIME(), SLEEP(), SUBDATE(), SUBTIME(), TIME_TO_SEC(), TIMEDIFF(), TIMESTAMPADD(), TIMESTAMPDIFF(), TO_DAYS().