Skip to Content
0
Former Member
Aug 03, 2016 at 06:28 PM

How to convert date field from .csv file to SAP HANA TIMESTAMP

2527 Views

Hi,

I am new to hana and would like some help. I imported flat file (.csv) into HANA. The date format is as below;

SQL DATA TYPE COLUMN STORE DATA TYPE

NVARCHAR STRING

I want to convert the existing time date format from 3/13/2016 -> TIMESTAMP 2016-03-13 11:09:00.0 (YYYY-MM-DD HH24:MI:SS).

I tried to change the data type to TIMESTAMP during the import process of the flat file but it throws an error, shown in attached.

Any help is much appreciated.

Attachments