How to calculate time difference

[janakiraman t]

Hi,

I have a column called timeinterval which is of type datetime. I need to select the first and the second timeinterval and find the difference between them. if it is greater than 30 seconds i need to do something. how to achieve this. I tried using datediff and timediff.

eg:
select TIMEDIFF ('2006-10-31 11:50:31' , '2006-10-31 11:50:01')
eg:
select DATEDIFF ('2006-10-31 11:50:31' , '2006-10-31 11:50:01')

but it is saying you have an error in sql syntax. Iam using mysql 4.1.0 version.

one more thing. If the query works fine how can i check whether it is greater than 30 seconds. If suppose it is greater than one day it is going to return 1. How to check this condition also.


Thanks
jankiraman