Skip to Content
Oct 24, 2019 at 02:24 PM

Using CPI DS for loading a file to hana db - Problem with date conversion

239 Views Last edit Oct 24, 2019 at 02:36 PM 2 rev


I am getting TEXT file where one of the columns is a date field in the format yyyymmdd .

Need to load this data into HANA DB on SCP.

please advise how to convert this to the format yyyy-mm-dd.

I tried the substring function , but am getting an error on using || for concatenat.. the conversion functions are insufficient for this kind of a conversion.

Appreicate your help.