You need to read the manual on date and time functions.
Convert each to seconds, subtract, and convert back to time.
You may have another problem, though.
You can't calculate an interval based solely on time.
You need the date too, unless all transactions are less than 24 hours
in length.
Paul C
Hi :
I am trying to calculate the time span of listing a large table database in mysql and
I run into trouble where I am trying to use curtime() - value stored in startime.But I
do not know how to get the stored value out from startime.Does anybody knows how I can
get value out from startime wh
