OUTSTANDING!  Here is a link I found to do it online:
http://javascript.internet.com/equivalents/unix-date-time-converter.html

Thanks,
Keith D Sellars
WebGraffix
www.webgraffix.com
 
"Making database sites seem easy"
 
----- Original Message ----- 
From: "Stephanie Thrasher" <steph(at)omsoft.com>
To: <hwg-languages(at)hwg.org>
Sent: Tuesday, April 29, 2003 10:06 PM
Subject: Re: MySQL base time?


> Hi Keith,
> 
> I'm hazy on this, but you're talking about epoch seconds, and you're
> right about the start date.  If you do a search for epoch time
> converters, you can find some online that'll do the conversion for
> you.
> 
> Stephanie
> 
> 
> 
> > One of my databases has a field titled "time" which records the time
> a
> > transaction occurs.  One such time is: 1051649099.
> >
> > I know this is in seconds and counts from a base date (don't know
> the
> > correct term for that starting date, so please forgive my
> ignorance).
> >
> > What is the actual date from which the time is based and what is the
> correct
> > term for that date?
> >
> > I thought the starting date was something like  Jan 01,1970 at
> midnight.
> > Assuming I am correct, then this date would represent April 5, 2003.
> >
> > Am I correct in this?
> >
> > Thanks,
> > Keith D Sellars
> > WebGraffix
> > www.webgraffix.com
> >
> > "Making database sites seem easy"
> >
> >
> >
> >
> 
> 
> 

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA