Skip to Content
Former Member
Apr 07, 2015 at 03:24 AM

Convert time 24 hour format to 12 hour format coming from non SAP source


hello all,

I have an oracle based source system and i have created DB Connect datasources for that in SAP BW.

I have a time field which is coming in 24hour format and i would want to convert that into 12 hour format.

issues faced -- when time in source is 12:08:19 AM, in BW it is converted into 240819 which is not plausible.

please suggest how to correct this error? is there a functional module for the same?