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

From: Valeri Sorokine <vsorokin_at_dd.ru>
Date: Tue, 08 Feb 2000 13:16:15 +0300
Message-ID: <389FECEF.C0E6C6D9_at_dd.ru>


Hello Igor,

Igor Faershtein wrote:
>
> Hi, Valeri !
>
> I don't know will it help to solve that problem, but why not to try to setup
> the short format of data with 'ÄÄ.íí.ÇÇÇÇ' / 'dd.MM.yyyy' value in menu
> "Language and standards"

[Quoted] Do you mean 'Regional Settings' ('Language and Standards' in Russian version)?

[Quoted] It won't work at all. Reports doesn't use Windows date settings, it usualy uses NLS_DATE_FORMAT environment variable, but the problem is that Reports 6.0.5.33.3 just ignores NLS_DATE_FORMAT for its date parameters...

[Quoted] Thank you for your response one more time.

Good Luck!  

> 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 Tue Feb 08 2000 - 11:16:15 CET

Original text of this message