Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Y2k problem with 7.3.4
I would recommend that you don't use the RR or RRRR format. See my message
entitled 'Date format RR limitations'. It only moves the problem to the year
2050. This may be enough but how many people said the same thing 20 years ago.
Either use the YYYY format or write your own function. As soon as you approach
the year 2050 the RR and RRRR format will behave, from a users point of view,
unexpectedly.
Best of luck.
"Carl A. Dotger" wrote:
> thank you all for your valuable suggestions... We are cuurently looking into
> inserting the date
> with the RR format...
>
> Thanks Again
Received on Wed Mar 03 1999 - 02:53:15 CST