Re: Date and year 2000?

From: Kim Ng <kimmng_at_eskimo.com>
Date: 1995/12/01
Message-ID: <DIw38E.7Jz_at_eskimo.com>#1/1


: My guess is that after the year 2000 the implicit century value may change
: to 20 (just like it is 19 now and assuming that 19 has not be "hard coded").
: So 05 and 95 would probably read as 2005 and 2095, respectively.
 

: Changing DD-MON-YY to DD-MON-RR would be a safer solution.

Yep, especially if somebody is making corrections to the dates and then saved it to the database!
eg: old date: 12/25/95 ----> Dec. 25, 1995

     corrected date done on Jan 5, 2000: 12/28/95 ----> Dec. 25, 2095

Fun isn't it :)

Kim Ng Received on Fri Dec 01 1995 - 00:00:00 CET

Original text of this message