extract

description

Syntax

INT extract(unit FROM DATETIME)

提取DATETIME某个指定单位的值。单位可以为year, month, day, hour, minute, second 或者 microsecond

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. -> extract(microsecond from cast('2022-09-22 17:01:30.000123' as datetimev2(6))) as microsecond;
8. +------+-------+------+------+--------+--------+-------------+
9. | year | month | day  | hour | minute | second | microsecond |
10. +------+-------+------+------+--------+--------+-------------+
11. | 2022 |     9 |   22 |   17 |      1 |     30 |         123 |
12. +------+-------+------+------+--------+--------+-------------+

keywords

1. extract