Symptom
The IQ data shows discrepancy in timestamp value with respective to its SAP ASE source.
Record in ASE:
select ID, ColTimestamp from MyTab where ID ='45612'
45612 2017-01-13 12:38:45.238
Record in IQ with Existing Prod Sybase IQ client
select ID, ColTimestamp from MyTab where ID ='45612'
45612 2017-01-13 12:38:45.233
Record in IQ After Upgrading Sybase IQ client
select ID, ColTimestamp from MyTab where ID ='45612'
45612 2017-01-13 12:38:45.236
Read more...
Product
Keywords
TIMESTAMP, DATETIME, Precision, milliseconds, accuracy, Load, Insert, ASE, discrepancy, compatibility , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.