List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 23 1999 5:09pm
Subject:64-bit Dates in MySQL
View as plain text  
>>>>> "Van" == Van  <vanboers@stripped> writes:

Van> Monty,
Van> How do you get around the 32-bit date limitation upper limit of 2038/01/19
Van> 03:14:07 GMT in MySQL?  I'm trying to write some c routines that will
Van> create the same output the the date_add('2038:01:19 03:14:07 GMT',interval
Van> 1 second) function would produce.  I notice in
Van> /usr/src/mysql-3.22.19b/mysys/mf_getdate.c that you use the tm struct for
Van> your calculations.  How are you getting this accomplished?
Van> Regards,
Van> Van

Hi!

MySQL has own date calculation for almost everything;  Only storing
and retrieving of timestamps depends on the time() and localtime().

You can find the functions in sql/time.cc and sql/item_timefunc.cc

Regards,
Monty

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