[aprssig] MySQL date

[Andrew Rich]

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


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