Re: Designer Date parameter Y2K problem

Addition, because previous wouldn't work

1. put key hklm\software\oracle\nls_date_format in registry , value: dd-mm-yyyy
2. alter key hklm\software\oracle\des2_70\execute_reports_runtime to $oracle_home\bin\r30run32.exe plsql_date_format=dd-mm-yyyy (just add the latter part)

Works for designer 2.1.2, I don't have 6.0 so I couldn't test that.

There is also a command line variable builtin_date_format and nvl_date format

Wim

Wim Jans <wim_at_cereus.be> wrote in article <01bf5858$a217d360$380210ac_at_wja.kodela.iuh.an>...
> Hello,
>
> Why don't you just set the nls_date_format to dd-mm-yyyy ?
>
> Wim
>
> TurkBear <johng_at_mm.com> wrote in article
> <38711b3f.26313526_at_news.dot.state.mn.us>...
> > In Designer ( both 2.1.2 and 6) there is a problem with the repository
> > reports..those that require a start and end date only accept 2 digit
> years,
> > which requires the user to have the nls_date_format set to dd-mon-rr
> >
> > I dislike the RR kludge and would prefer to use a 4 digit year...
> >
> > Has anyone found a way to modify the report parameters for the designer
> reports?
> >
> > Thanks,
> >
> >
>
Received on Thu Jan 06 2000 - 19:59:15 CET