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

[Quoted] Hi Valeri

[Quoted] In other versions of Reports (2.5.5.2.7 and 6.0.5.33.0), the input mask of the user parameter (i guess it's a user parameter, because of your syntax) controls the format which the date is saved in. Did you try to set the input mask to dd.mm.rrrr or dd.mm.yyyy ?

Regards
Pascal Glauser

In article <389AF75C.55FDA6B5_at_dd.ru>,   Valeri Sorokine <vsorokin_at_dd.ru> wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 09 2000 - 00:00:00 CET