<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.6000.16915" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>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. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have never seen a homeowners association or
politician so dutiful. They could take lessons from you.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
title=bbj@innismir.net href="mailto:bbj@innismir.net">Ben Jackson</A> </DIV>
<DIV><B>To:</B> <A title=aprssig@tapr.org href="mailto:aprssig@tapr.org">TAPR
APRS Mailing List</A> </DIV>
<DIV><B>Sent:</B> Sunday, November 08, 2009 12:28 PM</DIV>
<DIV><B>Subject:</B> Re: [aprssig] MySQL date</DIV></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT><BR></DIV><SPAN style="COLOR: navy"><SPAN
style="FONT-FAMILY: Prelude, Verdana, san-serif">Not trying to be rude Andrew,
but you've asked programming related questions here in the past and have been
met with silence. <BR><BR>Wouldn't it make sense to ask these to a discussion
list where these questions are on topic?<BR><BR></SPAN><SPAN id=signature>
<DIV
style="FONT-SIZE: 12px; COLOR: #999999; FONT-FAMILY: arial, sans-serif">--<BR>Ben
Jackson - <A href="mailto:bbj@innismir.net">bbj@innismir.net</A> - <A
href="http://www.innismir.net">www.innismir.net</A><BR>Sent from my Mobile
Device</DIV><BR></SPAN>
<HR style="WIDTH: 75%" align=left>
Andrew Rich wrote:<BR><BR>
<DIV><FONT face=Arial size=2>Hello</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Trying to work out a date diff function for APRS
sats</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The time diff is showing as getting "smaller" not
bigger even though my times are getting further apart</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>select timediff('2009-11-08 08:20:39','2009-11-07
19:04:22')</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ISS Last Heard<BR>13:16:17 </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>select timediff('2009-11-08 08:20:39','2009-11-07
19:06:10')</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ISS Last Heard<BR>13:14:29 </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Even when I reverse the times I get the same
result, just negative</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I would have expected it to increase as the
difference gets bigger between the two dates</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>"LAST HEARD HH:MM:SS" is my goal</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Andrew VK4TEC</FONT></DIV></SPAN>
<P>
<HR>
<P></P>_______________________________________________<BR>aprssig mailing
list<BR>aprssig@tapr.org<BR>https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig<BR></BODY></HTML>