SAP Knowledge Base Article - Preview

3057713 - Date values changed after import from CSV data via HANA Studio

Symptom

After import CSV data into tables via HANA Studio, the date values changed.

Example:

  • Before (in CSV data): 2020-09-03 15:20:25.03

csv data.png

  • After (in DB table): 2020-09-03 15:20:25.003

DB table.png

Images/data in this KBA are from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

HANA Studio 2.3.56 or lower.

Product

SAP HANA, platform edition 2.0

Keywords

HANA, HANA Studio, import, csv, date, wrong , KBA , HAN-STD-ADM-DBA , SAP HANA Studio (Eclipse) Admin Tooling , 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.