Eine Einführung in

SQL

Components of a date: such as the year or the month

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