quarter

description

Syntax

INT quarter(DATETIME date)

返回指定的日期所属季度，以INT类型返回

Example

1. mysql> select quarter('2022-09-22 17:00:00');
2. +--------------------------------+
3. | quarter('2022-09-22 17:00:00') |
4. +--------------------------------+
5. |                              3 |
6. +--------------------------------+

keywords

1. quarter