From: Van Date: March 23 1999 4:10pm Subject: 64-bit Dates in MySQL List-Archive: http://lists.mysql.com/mysql/836 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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 =========================================================================