D/MySQL
MySQL SECOND()
yeon.Biju
2020. 4. 3. 09:31
MySQL 날짜함수, 시간함수
SECOND()
- 시간에 대한 초를 return.
SECOND(time)
의 형태
Retruns the second for time, in the range 0 to 59.
mysql> SELECT SECOND(NOW());
+---------------+
| SECOND(NOW()) |
+---------------+
| 13 |
+---------------+
1 row in set (0.00 sec)
mysql> SELECT SECOND('10:11:07');
+--------------------+
| SECOND('10:11:07') |
+--------------------+
| 7 |
+--------------------+
1 row in set (0.00 sec)