Re: Date and year 2000?

Sridhar Pandari (pandaris_at_jecsun.cb.att.com) wrote:
: Hi,
: Does anybody know what will be the impact of our programs which use
: 'DD-MON-YY' date format once we cross the year 2000?
 

: Does ORACLE differentiate 05 and 95 in the YY field (say, as 2005 and 1995)?
 

: Sridhar
 

: --

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.

: \\/\\//
: | O O |

--
---------------------------------------------------------------------------
Kannan 
Email: skannan_at_fs.com
Mastech Systems Corporation

The above are my own comments and opinion. They do not purport that of 
anybody else.
       ** Different is Not Better. Better is not Different. **
---------------------------------------------------------------------------