2153424 - CAST function can not convert value to a timestamp in dbisql - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2153424 - CAST function can not convert value to a timestamp in dbisql - SAP IQ

Symptom

  • When running query that uses CAST to convert a string to a timestamp using dbisql, the following error occurs:

    >select CAST ('03/26/2015' AS datetime) AS Timestamp from dummy

    Cannot convert '03/26/2015' to a timestamp
        SQLCODE=-157, ODBC 3 State="07006"
  • The query works properly in isql.

 


Read more...

Environment

SAP IQ

Product

SAP IQ all versions

Keywords

interactive SQL , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , HAN-DYT , SAP HANA Dynamic Tiering , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.