Skip to Content

Change timestamp Format while loading data in SAP HANA

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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 19 at 09:04 PM

    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
    Add comment
    10|10000 characters needed characters exceeded