Re: Is FORMS 4.5 Y2K compliant ?

[Quoted] [Quoted] I believe this depends on the version of 4.5 you are running. The RR [Quoted] format is not recognised by the PL/SQL available before 1.6.1 - I think it [Quoted] just ignores RR

I've found the quickest workaround is to wrire a simple function which checks the format mask for RR and then either uses PL/SQL conversion (if not RR) or performs a SQL select if the mask contains RR

I have a function to do this but not right at hand - email if you would like a copy!

Regard
s

Alan Campbell <alan_at_mullen.demon.co.uk.nospam> wrote in article <365aad66.709976_at_news.demon.co.uk>...
> If I execute the follwoing code using FORMS 4.5 I get the error
> ORA-01839 which is telling me that the day part of the date is not
> valid for the month (the current system date is 29th February 2000).
>
> Current_Date := TO_CHAR(SYSDATE);
>
> MESSAGE(TO_CHAR(TO_DATE(Current_Date, 'DD-MON-RR')));
>
> Current date gets set to 20-FEB-00. the second line causes the error
> mentioned above.
>
> If I execute the same code using SQL+ it works OK.
>
> select TO_CHAR(TO_DATE('29-FEB-00', 'DD-MON-RR'))
> from sys.dual
>
> Gives me :-
>
> TO_CHAR(TO_DATE('29-FEB-00','DD-MON-RR'))
>
>