[aprssig] MySQL date

[K7FTP]

Thanks Ben.  It's good to know that the "on topic police" are out there, ever vigilant - to the point of using their mobile devices - protecting all of our best interests.  

I have never seen a homeowners association or politician so dutiful.  They could take lessons from you.    

On a serious note - it seems to be on-topic to me, and I find myself learning from such discussions.  If you don't like it, there is a little key marked DEL on your keyboard.  If you highlight the message and hit that button, it will make the message go away.  Please, use it.  

Sorry if my sarcasm is too much here, but I get tired of people policing mail lists.  Yes, sometimes things get way too far off topic, but I'd rather allow more leeway and encourage others to use their own delete keys.  If it gets too bad, then let the OFFICIAL list owner do something about it.  


----- Original Message ----- 
From: Ben Jackson 
To: TAPR APRS Mailing List 
Sent: Sunday, November 08, 2009 12:28 PM
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/aprssig_lists.tapr.org/attachments/20091108/f1bd8ade/attachment.html>