Flat file uploads in SAP HANA

[Former Member]

Hi All,

I am doing a flat file upload into SAP HANA. I have a date column in my flat file. I am not sure in what format i should store the data in excel to get the correct record in SAP HANA with DATA as the datatype. What should the date format be in excel.

DD-MM-YYYY

YYYY-MM-DD

YYYYMMDD

DDMMYYY

If i load the data in SAP HANA with datatype NVARCHAR the data gets loaded. But i want to load the data with data type as DATE.

Request you to please help

Regards

Nilesh

[former_member184768 · Accepted solution]

Hi Nilesh,

YYYY-MM-DD will work. Please ensure that it is shown in the same format when you try to load the file. If the excel data type is DATE, then you may see data in YYYY Mon DD in HANA Studio data preview for the file. Please change the data type to general and ensure the data format.

Regards,

Ravi

[Former Member]

You can use whatever format you want

IMPORT FROM '/location/file.ctl' WITH DATE FORMAT 'YYYY-MM-DD';

See the following link for more details

http://help.sap.com/hana/html/sql_import_from.html

John