List:General Discussion« Previous MessageNext Message »
From:Antoine Reid Date:March 23 1999 6:33pm
Subject:RE: 64-bit Dates in MySQL
View as plain text  
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]

Thread
64-bit Dates in MySQLVan23 Mar
  • 64-bit Dates in MySQLMichael Widenius23 Mar
RE: 64-bit Dates in MySQLVan23 Mar
  • RE: 64-bit Dates in MySQLAntoine Reid23 Mar