Y2k Problem
From: <KKPDC_at_HOTMAIL.COM>
Date: Mon, 04 May 1998 01:38:38 -0600
Message-ID: <6ijnpf$qf3$1_at_nnrp1.dejanews.com>
[Quoted] I am in the process of converting forms and reports for Y2K compliance. We are using forms 3.o and reports 1.1. The problems I face are listed below :
Date: Mon, 04 May 1998 01:38:38 -0600
Message-ID: <6ijnpf$qf3$1_at_nnrp1.dejanews.com>
[Quoted] I am in the process of converting forms and reports for Y2K compliance. We are using forms 3.o and reports 1.1. The problems I face are listed below :
- Is RR date is working inside Forms 3.?
- For the purpose of testing, I wrote a form function y2k(wdate in date)
- Starts here --- function y2k (fdate in date) return date is YY varchar2(2); NEW_DATE varchar2(12); begin YY := to_char(fdate,'YY'); if to_number(YY) between 0 and 50 then NEW_DATE := to_char(fdate,'dd-mon-') || '20' || YY; return (to_date(NEW_DATE,'dd-mon-yyyy')); else return(fdate); end if; end; ---------Ends here --------
I used this function as :adate := y2k(:adate); But I find the date still remain as 1900 and not as 2000. Could any one solve my problem please.
3. Is there any better approach ?
Krishna
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 04 1998 - 09:38:38 CEST