Skip to Content
0

Change timestamp Format while loading data in SAP HANA

Jun 21, 2017 at 06:10 AM

55

avatar image

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.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Samuel Muñoz 3 days ago
0

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
Share
10 |10000 characters needed characters left characters exceeded