[aprssig] MySQL date

[Andrew Rich]

Hello

Trying to work out a date diff function for APRS sats

The time diff is showing as getting "smaller" not bigger even though my times are getting further apart

select timediff('2009-11-08 08:20:39','2009-11-07 19:04:22')

ISS Last Heard
13:16:17 

select timediff('2009-11-08 08:20:39','2009-11-07 19:06:10')

ISS Last Heard
13:14:29 

Even when I reverse the times I get the same result, just negative

I would have expected it to increase as the difference gets bigger between the two dates

"LAST HEARD HH:MM:SS" is my goal

Andrew VK4TEC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/aprssig_lists.tapr.org/attachments/20091109/356ce02f/attachment.html>