Symptom
- INSERT ... SELECT ... from HANA table into DT table shifts all dates for TIMESTAMP/DATETIME columns one day down for any leap year
and then one day up for a subsequent year. - IMPORT directly from CSV file into DT table produces the same data shift for TIMESTAMP/DATETIME columns.
Read more...
Environment
HANA DT.
Product
SAP HANA 1.0, platform edition
Keywords
DATETIME, IMPORT, INSERT, HANA, Dynamic Tiering, wrong data, wrong result, 138060. , KBA , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.