Re: Is FORMS 4.5 Y2K compliant ?

under the format mask: type it RRRR , it should undertake the 2000 value.

regards.
nazh

In article <01be1851$46fdac40$1fa320cb_at_default>,   "Brian Membrey" <horsemth_at_mel.switch.net.au> wrote:
> I believe this depends on the version of 4.5 you are running. The RR
> format is not recognised by the PL/SQL available before 1.6.1 - I think it
> 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'))
> >
> >
> ---------------------------------------------------------------------------
> > 29-FEB-00
> >
> > Any ideas ?
> >
> > TIA
> >
> > Alan
> > ---
> > Alan Campbell
> > alan_at_mullen.demon.co.uk.nospam
> > Please remove .nospam to reply
> >
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 27 1998 - 05:08:54 CET