Mysql Time Operation

Mysql Time Operation performs the subtraction and addition of time.

Understand with Example

The Tutorial illustrate an example from Mysql Time Operation. To understand an example from Time Operation , we use keyword subtime (Time 1,Time2 ) that return you the time difference between time1 and time2.  

The Query given below :

subtime (time 1,time 2) : The subtime(time1,time2) return you the difference between time1 and time 2.

Query for Subtracting Time:-

mysql> select subtime('12:00:00','09:00:00')as SubstractedTime;

Output:-

+-----------------+
| SubstractedTime |
+-----------------+
| 03:00:00        |
+-----------------+
1 row in set (0.00 sec)

Query for Adding Time:-

The Query given below :

addtime (time1,time2) :The addtime(time1,time2) is used to add the time between time1 and time2.

mysql> select addtime('12:00:00','09:00:00')as TimeafterAddition;

Output:-

+-------------------+
| TimeafterAddition |
+-------------------+
| 21:00:00          |
+-------------------+
1 row in set (0.00 sec)