Home Sql Sqldate Mysql Time Operation



Mysql Time Operation
Posted on: June 9, 2009 at 12:00 AM
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)

Related Tags for Mysql Time Operation:
sqlmysqltimeiotutorialriaoperaexampletoexameilpeimfrommtroperationmeratetorxaxampsatratiomyimellmplstrtutorssrithstatipleplonomo


More Tutorials from this section

Ask Questions?    Discuss: Mysql Time Operation  

Post your Comment


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

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.