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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.