This content has been marked as final. Show 3 replies
805574 wrote:Please see these docs.
I have text format date (26-MAR-1999) . When I am converting the to Date format using the CAST function I am getting below Error.
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59140] The evaluation of the index 1 expression on row count -1 failed. [nQSError: 46047] Datetime value 26-MAR-1999 from 26-MAR-1999 does not match the specified format. (HY000)
Data Base : Essbase 11.1.2
Could you please help me.
OBIEE 10g: Error: "View Display Error A date value was expected (received "2008-04-01 00:00:00")" Using a Dashboard Prompt [ID 847776.1]
Calendar Control Gives An Error: Datetime Value 1/1/2009 Does Not Match The Specified Format [ID 816663.1]
PROBLEM TO FILTER A COLUMN WITH A PARAMETER OF TYPE DATE [ID 605803.1]
Essbase : [nQSError: 46046] Datetime value 03-25-1996 does not match the specified format. (HY000) [ID 1113626.1]
thanks for the reply.
can you please attch the doc.
can you please attch the doc.You can access the docs via Oracle MOS website -- https://support.oracle.com
You need to have a valid username/password and CSI number to access MOS website. Posting the contents of MOS docs violates Oracle support agreement policy.