1 Reply Latest reply on Oct 14, 2013 7:46 AM by Steven Hawkins

    Error When executing Query contains MONTHNAME()

    Joseph CHIDIAC Novice

      I tried to execute the following query :

       

      SELECT  MONTHNAME(  OrderDate  ) FROM tbOrders  

       

      i got the following erros : TEIID10076 Invalid conversion from type class org.teiid.core.types.BinaryType with value '4D6179' to type class java.lang.String

      08:56:59,258 WARN  [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue31)

      8CRH1TD+GCK/ TEIID30020 Processing exception for request 8CRH1TD+GCK/.0 'TEIID10076

      Invalid conversion from type class org.teiid.core.types.BinaryType with value '4D6179' to type class java.lang.String'.

      Originally TransformationException DataTypeManager.java:924. Enable more detailed logging to see the entire stacktrace.

       

       

      if i replace MONTHNAME by MONTH()  i got  a result.