List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 1 1999 9:40pm
Subject:Re: MYSQL year 2069 complaint
View as plain text  
>>>>> "Steve" == Steve Ruby <stever@stripped> writes:

Steve> unix_timestamp() function appears to break around 2038 so 
Steve> becarefull what you use to compare dates well into the future.

Before 2038, the Unix systems will to use for a timestamp:

- An unsigned 32 bit value instead of an ulong
  (This will be safe with until 21xx something)
- A 64 bit value.

In either case, MySQL should work until 21xx with the current
MySQL TIMESTAMP implementation (MySQL will continue to store the
timestamp as an unsigned 32 int until 2099.  We plan to fix this in 
MySQL version 13.0).

Regards,
Monty
Thread
MYSQL year 2069 complaintKesavan J1 Sep
  • Re: MYSQL year 2069 complaintPaul DuBois1 Sep
    • Re: MYSQL year 2069 complaintSteve Ruby1 Sep
      • Re: MYSQL year 2069 complaintMichael Widenius2 Sep
        • Re: MYSQL year 2069 complaintSteve Ruby2 Sep
          • Re: MYSQL year 2069 complaintEd Carp2 Sep
          • Re: MYSQL year 2069 complaintMichael Widenius2 Sep