[aprssig] MySQL date

Andrew Rich vk4tec at tech-software.net
Sun Nov 8 14:30:33 EST 2009

Sorted - I had a 24 hour offset - sorry

  ----- Original Message ----- 
  From: Andrew Rich 
  To: TAPR APRS Mailing List 
  Sent: Monday, November 09, 2009 5:08 AM
  Subject: MySQL date


  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

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

  ISS Last Heard

  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/0956ac14/attachment.html>

More information about the aprssig mailing list