Share on Google+Share on Google+

Mysql Time Operation

Advertisement
Mysql Time Operation performs the subtraction and addition of time.

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

Advertisement

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

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Discuss: Mysql Time Operation  

Post your Comment


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