Re: Forms 3.0, Rpt and Year 2000

> Eg if you are dealing with Birthdates, its possible that the birthdate of
> 01-FEB-45 is a legitamate one for a person living now, however the RR option
> gives this on our Y2K test box:
>
> select substr(to_char(sysdate,'DD-MON-YYYY'), 1,13)
> from dual;
> -- more >
> SUBSTR(TO_CHA
> -------------
> 16-FEB-2000
>
> select substr(
> to_char(
> to_date('01-FEB-45','DD-MON-RR'),
> 'DD-MON-YYYY'), 1,13)
> from dual;
>
> SUBSTR(TO_CHA
> -------------
> 01-FEB-2045
>
> We have a proceduure that treats dates of birth seperately.
>

[Quoted] Could you please post this procedure. I am very much interested

Thanks,

Michael Received on Mon Jul 06 1998 - 18:53:31 CEST