[aprssig] MySQL date

[Andrew Rich]

Straight away someone helped me !

You don't get to see the direct email help


  ----- Original Message ----- 
  From: Ben Jackson 
  To: TAPR APRS Mailing List 
  Sent: Monday, November 09, 2009 5:28 AM
  Subject: Re: [aprssig] MySQL date


  Not trying to be rude Andrew, but you've asked programming related questions here in the past and have been met with silence. 

  Wouldn't it make sense to ask these to a discussion list where these questions are on topic?


  --
  Ben Jackson - bbj at innismir.net - www.innismir.net
  Sent from my Mobile Device


------------------------------------------------------------------------------
  Andrew Rich wrote:


  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


------------------------------------------------------------------------------


  _______________________________________________
  aprssig mailing list
  aprssig at tapr.org
  https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig



------------------------------------------------------------------------------



  No virus found in this incoming message.
  Checked by AVG - www.avg.com 
  Version: 8.5.425 / Virus Database: 270.14.54/2488 - Release Date: 11/07/09 23:52:00
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/aprssig_lists.tapr.org/attachments/20091109/ed147a6d/attachment.html>