<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Thanks Bruce !</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV> </DIV>
<DIV>----------------------------------------------------------<BR>Andrew Rich
<BR>Airways Technical Officer Grade 4<BR>Surveillance - RADAR ADS-B<BR>Amateur
Radio Callsign VK4TEC<BR>email: <A
href="mailto:vk4tec@tech-software.net">vk4tec@tech-software.net</A><BR>web: <A
href="http://www.tech-software.net">www.tech-software.net</A></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=ki4cpz@arrl.net href="mailto:ki4cpz@arrl.net">Bruce Kreutzer</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=vk4tec@tech-software.net
href="mailto:vk4tec@tech-software.net">Andrew Rich (Home)</A> ; <A
title=aprssig@tapr.org href="mailto:aprssig@tapr.org">TAPR APRS Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 02, 2009 8:45
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [aprssig] Wanted perl time
code</DIV>
<DIV><BR></DIV>Andrew-<BR><BR>Perl has loads of time functionality. The
solution depends on what format the date you have is in. There is also
very good perl documentation online. For example, google perl time
diff.<BR>I found this page as an overview: <A
href="http://www.perl.com/lpt/a/718">http://www.perl.com/lpt/a/718</A><BR><BR>You
can just subtract times in internal format: $difftime = time() -
$prevtime;<BR>Then print it using gmtime() to extract the individual values
like this:<BR>my @z = gmtime($difftime);<BR>print "<FONT size=2 face=Arial>It
has been $z(3) days, $z(2) hours, $z(1) minutes, $z(0) seconds since we last
heard xxxx";<BR><BR>(I haven't tried to actually run this code, but it should
work).<BR><BR>There may be easier/better/faster ways to write this, but it's
readable, more or less.<BR><BR>I can't answer the mysql
question.<BR><BR>Bruce<BR>ki4cpz<BR></FONT><BR>
<DIV class=gmail_quote>On Wed, Sep 2, 2009 at 4:37 AM, Andrew Rich (Home)
<SPAN dir=ltr><<A
href="mailto:vk4tec@tech-software.net">vk4tec@tech-software.net</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV bgcolor="#ffffff">
<DIV><FONT size=2 face=Arial>Hello</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I am looking for some perl code that can tell
me the days, hours, minutes and seconds between two events</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Actually what I want is "It has been xxx since
we last heard xxxx"</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Ideas ?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Does MySQL have a time diff function
?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2
face=Arial>----------------------------------------------------------<BR>Andrew
Rich <BR>Airways Technical Officer Grade 4<BR>Surveillance - RADAR
ADS-B<BR>Amateur Radio Callsign VK4TEC<BR>email: <A
href="mailto:vk4tec@tech-software.net"
target=_blank>vk4tec@tech-software.net</A><BR>web: <A
href="http://www.tech-software.net"
target=_blank>www.tech-software.net</A></FONT></DIV></DIV><BR>_______________________________________________<BR>aprssig
mailing list<BR><A href="mailto:aprssig@tapr.org">aprssig@tapr.org</A><BR><A
href="https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig"
target=_blank>https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig</A><BR><BR></BLOCKQUOTE></DIV><BR>
<P>
<HR>
<P></P><BR>No virus found in this incoming message.<BR>Checked by AVG -
www.avg.com <BR>Version: 8.5.409 / Virus Database: 270.13.75/2340 - Release
Date: 09/01/09 20:03:00<BR></BLOCKQUOTE></BODY></HTML>