Re: Oracle and Year 2000

For the best answer I refer to Oracle Support, your neighborhood DBA, or if you're desperate, the Oracle Website. The "RR" year type was introduced (in 7.3, perhaps?) to accommodate the two or three decades on either side of the century mark, to wit: for dates 1970 - 2030 (my best guess from memory), any datefield comparisons will handle the years up to "99" as 20th century, and "00 - 30" as the 21st.

JMTC,
Dave

Michael wrote:
>
> I need to make some forms millenium-proof.
> Some say that using dateformat DD-MM-RRRR in stead of DD-MM-YYYY does
> the job, others say it is just a media hype. Who should I believe?
> I use Forms4.5 (if this is of any importance).
>
> Thanks to anyone who can help me out on this
>
> Michael

-- 
Dave Van Zandt
(work) david.vanzandt_at_alcoa.com
(pers) dvanzandt_at_iquest.net  http://members.iquest.net/~dvanzandt