Mysql Time Operation

Mysql Time Operation performs the subtraction and addition of time.


 
Ads

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)

Advertisements

Share on Google+Share on Google+

Mysql Time Operation

Posted on: June 9, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: Mysql Time Operation  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads