Re: Oracle and Year 2000

I disagree,

Most nice way is to use the dd-mm-rrrr format in the screen so that your users have the possibilty to enter two digits and see four.

On the database you should have dd-mm-rrrr.

Peter
TurkBear heeft geschreven in bericht <35855a94.13894218_at_news2.mm.com>...
>Michael <michael1_at_xs4all.nl> 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
>>
>To ensure Y2k compliance within a form, use the field format string
>FXMM-DD-YYYY or any Month,Day,year format that uses YYYY as the year -
>the FX preceding the 'actual' format will force users of the form to
>enter the date exactly as formatted -
>Set the database date format to DD-MM-YYYY since, with forced 4-digit
>year input, it will always be correct....( assuming your users know
>the correct date ! )
>
>Hope it helps,
>John Greco
>Oracle DBA
>
>
>
Received on Wed Jun 17 1998 - 19:53:28 CEST