3589377 - Unable to use CAST() function in a column of a table in SAP IQ

• An issue arises when trying to convert a string in a column to a datetime value in a table of SAP IQ. (Other types of value will have this same issue, example: select cast('20200102030405' as datetime); );
  
  
• Could not execute the statement.
  Column 'a' not found
  SQLCODE=-143, ODBC 3 State="42S22"
  Line 1, column 1
  
  
• The problem also occurs when adding million seconds or microseconds to the string. (Example: select cast('20200102030405111222' as datetime); );
  
  
• There was an error reading the results of the SQL statement.
  The displayed results may be incorrect or incomplete.
  Cannot convert '20200102030405111222' to timestamp
  SQLCODE=-157, ODBC 3 State="07006"
  Line 1, column 1

Sybase IQ

SAP IQ, string to datetime, cast, SQLA, IQ engine, constant expression, table expression, fractional digits, column, type. , KBA , BC-SYB-IQ , Sybase IQ , Problem