Order Tray | Contact Us | Home | SIG Lists

[aprssig] MySQL date

Andrew Rich vk4tec at tech-software.net
Sun Nov 8 19:08:58 UTC 2009


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://www.tapr.org/pipermail/aprssig/attachments/20091109/356ce02f/attachment.htm>


More information about the aprssig mailing list