BUG in Reports 6.0.5.33.3 (Date parameter uses two digit only) (?)
From: Valeri Sorokine <vsorokin_at_dd.ru>
Date: Fri, 04 Feb 2000 18:59:24 +0300
Message-ID: <389AF75C.55FDA6B5_at_dd.ru>
[Quoted] It seems that Reports 6.0.5.33.3 (patch 5a) has a bug:
Date: Fri, 04 Feb 2000 18:59:24 +0300
Message-ID: <389AF75C.55FDA6B5_at_dd.ru>
[Quoted] 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 [Quoted] 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.ruReceived on Fri Feb 04 2000 - 16:59:24 CET