Re: MySQL base time?

Here is a text from "Programming Perl" by Larry Wall:

The built-in time function will always return the number of seconds
since the beginning of the "epoch", but operating systems differ in
their opinions of when that was. On many systems, the epoch began on
January 1, 1970, at 00:00:00 UTC, but it began 66 years earlier on Macs,
and on VMS it began on November 17, 1858, at 00:00:00.


Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: orasnita(at)home.ro

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


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