Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to convert SAP dateTime field to Oracle date field

Hi All,

We have a scenario where the incoming data is in the following format:

< ReconciliationData >

< RowID > 9 </ RowID >

< Run_ID > 7 </ Run_ID >

< Control_ID > 5.40 </ Control_ID >

< Control_Name > MTD CHARGES TO CARP ORDERS INVENTORY </ Control_Name >

< Start_Month > 008 </ Start_Month >

< End_Month > 008 </ End_Month >

<b> < SAP_Time > 20070828190545 </ SAP_Time > </b>

< SAP_Count > 4 </ SAP_Count >

< SAP_Amount > 5000.00 </ SAP_Amount >

</ ReconciliationData >

On the receiver side is oracle database. SAP TIME field has to go into Oracle Date field. it should be transformed to structure yyyy/mm/dd hh:mm:ss format.

How do i go about doing it?

Regards,

XIer

Former Member
Not what you were looking for? View more on this topic or Ask a question