How to convert SAP dateTime field to Oracle date field

[Former Member]

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]

hey

did u try the DateTrans function?if that does not work then u can write a simple UDF for it

http://help.sap.com/saphelp_nw04/helpdata/en/43/c4cdfc334824478090739c04c4a249/frameset.htm

Thanx

Aamir

[Former Member]

Any help guys on this?

[justin_santhanam]

XIer,

Did u tried with DateTrans function.

raj.