SAP Knowledge Base Article - Preview

2420752 - Load table with quotes on and letter in between datetime results in error - SAP IQ


  • Load a file in the table which has the timestamp format with T and in double quotes. For example: “2017-01-17T10:20:3”.
  • Even after including the option ‘QUOTES ON’, an error is thrown and the file is not loaded.

Cannot convert "2017-10-17T10:20:3 to a datetime(23) (column field2) SQLCODE=-157, ODBC 3 State="07006" Line1, column 1



SAP IQ16 SP11 PL05


SAP IQ 16.0


 CR 805234; CR#805234; 805234; , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

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

Search for additional results

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