That makes a lot of sense actually.  I think you are right, because I've
always understood the epoch date to be the same thing on either server type.

Thanks,
Keith D Sellars
WebGraffix
www.webgraffix.com

"Making database sites seem easy"

----- Original Message -----
From: "Rajnish Bhaskar" <r.bhaskar(at)compserv.gla.ac.uk>
To: "Keith D Sellars" <Keith(at)webgraffix.com>; "Keith D Sellars"
<Keith(at)webgraffix.com>
Cc: <hwg-languages(at)hwg.org>
Sent: Wednesday, April 30, 2003 7:47 AM
Subject: Re: MySQL base time?


> Hi Keith,
>
> > Note: The valid range of a timestamp is typically from Fri, 13 Dec
> > 1901 20:45:54 GMT to Tue, 19 Jan 2038 03:14:07 GMT. (These are the
> > dates that correspond to the minimum and maximum values for a 32-bit
> > signed integer). On windows this range is limited from 01-01-1970 to
> > 19-01-2038.
>
> Hmm, I didn't see that (but then, I wasn't looking too closely :o)
> ).  Thinking about it, it's very possible (and probably, actually)
> that the epoch value is still 1/1/1970 on Unix, but you get the
> earlier dates by having negative numbers.
>
> Raj.
>
>

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