| MySQL | ||
| We can extract the year, the month, the day of the month and the day of the week. Times may be extracted in a similar way. The SQL Standard specifies the understandably unpopular EXTRACT function. | ||
| Specific to MySQL | ||
| Other functions... DAYOFMONTH DAYOFWEEK DAYOFYEAR DAYNAME HOUR MINUTE MONTH MONTHNAME QUARTER SECOND WEEK WEEKDAY YEAR YEARWEEK | ||