D/MySQL
MySQL MINUTE()
yeon.Biju
2020. 4. 2. 13:42
MySQL 날짜함수, 시간함수
MINUTE()
- 시간으로부터 분(minute)을 구하는 함수
MINUTE(time)
의 형태
Returns the minute for time, in the range of 0 to 59.
mysql> SELECT MINUTE(NOW());
+---------------+
| MINUTE(NOW()) |
+---------------+
| 42 |
+---------------+
1 row in set (0.00 sec)
mysql> SELECT MINUTE('11:45');
+-----------------+
| MINUTE('11:45') |
+-----------------+
| 45 |
+-----------------+
1 row in set (0.00 sec)