Change timestamp Format while loading data in SAP HANA

[smanghnani23]

I want to load the data to SAP HANA from a csv file which is having a timestamp data but with different format (10/5/2017 10:30:00 PM &

10-5-2017 10:30:00 PM ) I want to make it to a single format while loading to hana DB. can anyone plz suggest the answer. it will be very helpful to me.

[former_member533736 · Accepted solution]

Hello, I recommend you make a load to a temporary table, then make the transformation and conversion of this field to finally bring the data to the physical table