List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 1 1999 11:38am
Subject:Re: MYSQL year 2069 complaint
View as plain text  
At 6:29 AM -0500 9/1/99, Kesavan J wrote:
>Respected Sir,
>
>I went through the mysql documentation. I have some clarification
>regarding date.
>You have illustrated that there is no problem until year 2069. I want to
>know what
>will happen after the year 2069.

Can you be more specific?  If you're referring to the DATE type,
it has a range up to the year 9999.

If you're asking about the rules that MySQL uses to convert 2-digit
year values to 4-digit year values, the answer is that you should
be using unambiguous data if you're concerned about how a program
makes the conversion.  That's true for any program, not just MySQL.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
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