[aprssig] MySQL date

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

But they are - people running APRS servers like findu aprs.fi use MySQL 

Silence ? I have had great success - there are some reall smarties on here 

And besides - the output benefits HAM RADIO


  ----- 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/764d250d/attachment.html>

More information about the aprssig mailing list