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?