Re: Discoverer 4i ORA-01821: Date format not recognized

Bug 729977

Thanks to my Oracle consultant..

Ai Nguyen

"Ai Nguyen" <ai_oy_at_yahoo.com> a écrit dans le message de news: 4Iw6a.1392$VG.290966_at_news20.bellglobal.com...
> Hi,
>
> I am using Discoverer 4i Administration (AE) and User (UE) Editions
(French
> versions) , v 4.1.37.00.0
> on an 8.1.7.2.1 database; both are on Win NT (Workstation and Server).
>
> I use the Default Date Hierarchy (YYYY>Quarter>Mon>DD) on a DATE column
> named MS RELV in the Discoverer AE.
>
> In the Discoverer UE, when I try to extract one of these calculated items:
> Year, Month, or Day,
> I get the message : ORA-01821: Date format not recognized.
> However, I get no message with the item Quarter. The values are returned
as
> they should with Quarter => Q1,Q2,Q3,or Q4.
>
> I did not find anything on metalink.
> ______________
> ORA-01821
> ORA-01821date format not recognized
> Cause:A date specification contained an invalid format code.
> Action:Ensure only valid date format codes are specified.
> _______________
> Year is defined as EUL_DATE_TRUNC(MS RELV,'YYYY')
> Quarter is defined as EUL_DATE_TRUNC(MS RELV,'"Q"Q')
> Month is defined as EUL_DATE_TRUNC(MS RELV,'Mon')
> Day is defined as EUL_DATE_TRUNC(MS RELV,'DD')
>
> What is wrong with the date formats used in the function????
> ___
>
> Can someone explain what is going on????
>
> Does this have to do with language settings ?
>
> Many thanks in advance.
>
>
Received on Wed Feb 26 2003 - 22:26:55 CET