mysql
MYSQL - TIMEDIFF 함수
expr1 에 expr2의 값을 뺀 나머지를 반환합니다.
SELECT TIMEDIFF(EXPR1, EXPR2);
#ex.1)
mysql> SELECT TIMEDIFF('2000:01:01 00:00:00', '2000:01:01 00:00:00.000001');
-> -00:00:00.000001
mysql> SELECT TIMEDIFF('2000-01-02 00:00:00', '2000-01-01 00:00:00.000001');
-> 23:59:59.999999
0 댓글