Symptom
When loading table from a flat text file, if you need to load NULL value into a date, datetime or timestamp column, you may encounter the following error:
Cannot convert NULL to a date/datetime/timestamp ...
Read more...
Environment
- SAP IQ 15.X
- SAP IQ 16.X
Product
SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4
Keywords
SYBASE IQ Load NULL date datetime timestamp , KBA , BC-SYB-IQ , Sybase IQ , How To
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.