D/MySQL
MySQL QUARTER()
yeon.Biju
2020. 4. 2. 14:44
MySQL 날짜함수, 시간함수
QUARTER()
- 날짜를 이용해서 분기를 구해주는 함수
QUARTER(date)
의 형태
Returns the quarter of the year for date, in the range 1 to 4.
mysql> SELECT QUARTER(NOW());
+----------------+
| QUARTER(NOW()) |
+----------------+
| 2 |
+----------------+
1 row in set (0.00 sec)
mysql> SELECT QUARTER('2010-11-30');
+-----------------------+
| QUARTER('2010-11-30') |
+-----------------------+
| 4 |
+-----------------------+
1 row in set (0.00 sec)