Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 06, 2007 at 01:32 AM

    XIer,

    Did u tried with DateTrans function.

    raj.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2007 at 01:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded