SAP Knowledge Base Article - Preview

2420719 - Behavior difference loading TIMESTAMP data into Extended Storage table for leap year and year after leap -- HAN DYT

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.