How to get part of date in MySQL?

By using EXTRACT() function we can get the current date or part of a given date. Parts of the date can be obtained as year, month, day, hour, minute, second, and microsecond.

Example

mysql> Select EXTRACT(Year from NOW()) AS YEAR; +-------+ | YEAR | +-------+ | 2017| +-------+ 1 row in set (0.00 sec)

The above MySQL query will get the year from the current date.

mysql> Select EXTRACT(Month from '2017-09-21')AS MONTH; +-------+ | MONTH | +-------+ | 9 | +-------+ 1 row in set (0.00 sec)

The above MySQL query will get the month for a given date.

The above is the detailed content of How to get part of date in MySQL?. For more information, please follow other related articles on the PHP Chinese website!