extract

description

Syntax

INT extract(unit FROM DATETIME)

Extract DATETIME The value of a specified unit. The unit can be year, day, hour, minute, or second

Example

  1. mysql> select extract(year from '2022-09-22 17:01:30') as year,
  2. -> extract(month from '2022-09-22 17:01:30') as month,
  3. -> extract(day from '2022-09-22 17:01:30') as day,
  4. -> extract(hour from '2022-09-22 17:01:30') as hour,
  5. -> extract(minute from '2022-09-22 17:01:30') as minute,
  6. -> extract(second from '2022-09-22 17:01:30') as second;
  7. +------+-------+------+------+--------+--------+
  8. | year | month | day | hour | minute | second |
  9. +------+-------+------+------+--------+--------+
  10. | 2022 | 9 | 22 | 17 | 1 | 30 |
  11. +------+-------+------+------+--------+--------+

keywords

  1. extract