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

From: Valeri Sorokine <vsorokin_at_dd.ru>
Date: Thu, 10 Feb 2000 13:47:37 +0300
Message-ID: <38A29749.9435B77C_at_dd.ru>


Hi Pascal,

It seems that it's a very nice workaround for that bug in Reports Runtime 6.0.5.33.3 :-)

Thank you very much for your idea! It works.

I sould add that the bug is in Reports Runtime, not in Reports Builder which works without this bug... Next time I'll be more accurate...

So, we have a great workaround but I hope it'll be fixed in the next version...

Sincerely,

Valeri

Pascal Glauser wrote:
>
> Hi Valeri
>
> 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.

-- 
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 Thu Feb 10 2000 - 11:47:37 CET

Original text of this message