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