Isn't the DATETIME in mysql stored in 8 bytes?
It says in documentation
that the valid range for DATETIME is '1000-01-01 00:00:00' to '9999-12-31
just my 2cents CDN (not worth too much nowadays..)
On Tue, 23 Mar 1999, Van wrote:
> Date: Tue, 23 Mar 1999 12:01:45 -0500 (EST)
> From: Van <vanboers@stripped>
> To: mysql@stripped
> Subject: RE: 64-bit Dates in MySQL
> That's just it, Dayv. the problem is with trying to count 2^31 seconds
> before, or after the UNIX epoch 1970-01-01.
> If you do a select date_add("1900-01-01 12:00:00", interval 1 day);
> you get the correct date in mysql. I'm just wondering how Monty and crew
> got around this. Specifically, I'm trying to create some 64 bit function
> calls for Linux and HP-UX for some Y2K testing.
> Linux rocks!!! www.dedserius.com