Re: Date problems since 2000

Cefio wrote:
>
> Hi
>
> I have encounterd a problem with my oracle version 7.3
> I have a table containing records with a date field ("DD/MM/YY")
> Since year 2000, all records with an year "99" are interpreted "2099"
> inspite of "1999"
> Can i result this problem ??

   Use "DD/MM/RR" format instead of "DD/MM/YY"    Or better "DD/MM/YYYY" or "DD/MM/RRRR"

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia