The conversion error
Data type conversion is not possible. Conversion of 'September 25 2021' to data type date failed.
-- (dflib\dfe_HDBValue.cxx 468)
SQLCODE=-1009145, ODBC 3 State="HY000"
- on a database using UTF8BIN collation
- when comparing a date column with a string containing 'September': select * from tab1 where datecol = 'September 25 2021';
- 'September' has 9 chars.
- The other months are less than 8 chars and no error is fired.
SAP IQ 16.1
823329, CR823329, CR#823329, UTF8BIN, September, "Data type conversion is not possible", "Data type conversion is not possible", "to data type date failed" , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.