List:General Discussion« Previous MessageNext Message »
From:Van Date:March 23 1999 5:01pm
Subject:RE: 64-bit Dates in MySQL
View as plain text  
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
=========================================================================

On Tue, 23 Mar 1999, Dayv Gastonguay wrote:

> Theres a little problem with that date.  Unix cannot recognize any dates
> beyond then.  They've got 39 years left to get a patch out though :)
> 
> -----Original Message-----
> From: Van [mailto:vanboers@stripped]
> Sent: Tuesday, March 23, 1999 11:11 AM
> To: mysql@stripped
> Subject: 64-bit Dates in MySQL
> 
> 
> Monty,
> How do you get around the 32-bit date limitation upper limit of 2038/01/19
> 03:14:07 GMT in MySQL?  I'm trying to write some c routines that will
> create the same output the the date_add('2038:01:19 03:14:07 GMT',interval
> 1 second) function would produce.  I notice in
> /usr/src/mysql-3.22.19b/mysys/mf_getdate.c that you use the tm struct for
> your calculations.  How are you getting this accomplished?
> Regards,
> Van
> 
> =========================================================================
> Linux rocks!!!   www.dedserius.com
> =========================================================================
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread836@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 
> 

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