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.