<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18852">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Straight away someone helped me !</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>You don't get to see the direct email
help</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=bbj@innismir.net href="mailto:bbj@innismir.net">Ben Jackson</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=aprssig@tapr.org
href="mailto:aprssig@tapr.org">TAPR APRS Mailing List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, November 09, 2009 5:28
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [aprssig] MySQL date</DIV>
<DIV><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-FAMILY: arial, sans-serif; COLOR: #999999; FONT-SIZE: 12px">--<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 size=2 face=Arial>Hello</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Trying to work out a date diff function for APRS
sats</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>The time diff is showing as getting "smaller" not
bigger even though my times are getting further apart</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>select timediff('2009-11-08 08:20:39','2009-11-07
19:04:22')</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>ISS Last Heard<BR>13:16:17 </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>select timediff('2009-11-08 08:20:39','2009-11-07
19:06:10')</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>ISS Last Heard<BR>13:14:29 </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Even when I reverse the times I get the same
result, just negative</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I would have expected it to increase as the
difference gets bigger between the two dates</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>"LAST HEARD HH:MM:SS" is my goal</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>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>
<P>
<HR>
<P></P><BR>No virus found in this incoming message.<BR>Checked by AVG -
www.avg.com <BR>Version: 8.5.425 / Virus Database: 270.14.54/2488 - Release
Date: 11/07/09 23:52:00<BR></BLOCKQUOTE></BODY></HTML>