Time difference between TIMESTAMP fields

[markhartnady]

Anyone know how to return the difference in time (in seconds) between two TIMESTAMP fields?

I am using MySQL ver 4.0.12 thus TIMEDIFF and all those other fancy functions dont work!

[weronpc]

SELECT SECOND(TIMEDIFF(expr,expr2));

or

SELECT MICROSECOND(TIMEDIFF(expr,expr2));

I never try it out, but let me know if it works or not.

[markhartnady]

Read above!!!

I am using MySQL ver 4.0.12 thus TIMEDIFF and all those other fancy functions dont work!

[weronpc]

I am so sorry Mark, I didn't read carefully.

how about this?

select second(date_time) - second(date_time_2) as different_time;

[markhartnady]

That might work! I'll give it a shot. Thanks.