[aprssig] MySQL date

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

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:


  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


  aprssig mailing list
  aprssig at tapr.org


  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>

More information about the aprssig mailing list