From: Antoine Reid
Date: March 23 1999 6:33pm
Subject: RE: 64-bit Dates in MySQL
List-Archive: http://lists.mysql.com/mysql/842
Message-Id: <Pine.LNX.3.96.990323132839.15524B-100000@Woody.Jonction.NET>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


Isn't the DATETIME in mysql stored in 8 bytes?
:)

It says in documentation
(http://www.mysql.com/Manual_chapter/manual_Reference.html#DATETIME)
that the valid range for DATETIME is '1000-01-01 00:00:00' to '9999-12-31
23:59:59'

just my 2cents CDN (not worth too much nowadays..)
Antoine Reid
areid@stripped
Sysadmin, InterJonction
(514) 288-1105

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.
> Van
> 
> =========================================================================
> Linux rocks!!!   www.dedserius.com
> =========================================================================
[snip]