Is FORMS 4.5 Y2K compliant ?

From: Alan Campbell <alan_at_mullen.demon.co.uk.nospam>
Date: Mon, 23 Nov 1998 18:46:02 GMT
Message-ID: <365aad66.709976_at_news.demon.co.uk>

[Quoted] 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
[Quoted] Please remove .nospam to reply Received on Mon Nov 23 1998 - 19:46:02 CET