Re: BUG in Reports 6.0.5.33.3 (Date parameter uses two digit only) (?)

[Quoted] Hi, Valeri !

[Quoted] [Quoted] I don't know will it help to solve that problem, but why not to try to setup [Quoted] the short format of data with 'ÄÄ.íí.ÇÇÇÇ' / 'dd.MM.yyyy' value in menu "Language and standards"

[Quoted] Sorry, I cant try it because of the absence of Reports 6 on my PC.

Best Regards !
Igor

->Valeri Sorokine
-> It seems that Reports 6.0.5.33.3 (patch 5a) has a bug:
->
-> Despite of NLS_DATE_FORMAT = 'DD.MM.YYYY' in registry, Reports
-> 6.0.5.33.3 uses two digit only to store date in date parameter...
->
-> This code:
->
-> :p_Date := TO_DATE('01.01.1999','DD.MM.YYYY');
-> srw.message(0,'p_Date = '||TO_CHAR(:p_Date,'DD.MM.YYYY'));
->
-> will show you
->
-> MSG-00000: p_Date = 01.01.2099
->
-> So, be aware of it...
->
-> P.S. Reports 6.0.5.32.0 works just fine with it.
->
-> --
-> Valeri Sorokine
-> Oracle Certified Application Developer, Rel.2
-> ProSoft, Russia, Moscow, Information Systems Division
-> Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
-> E-mail: vsorokin_at_dd.ru ; http://www.dd.ru
Received on Mon Feb 07 2000 - 17:47:39 CET