How to change broker date fromat in Oracle Intelligent adapter

, , ,
1

I have a date string coming in… I want to change the format of the date from 20020405z to 04/05/2002

in oracle intelligent adapter. how can i do that?

2

Hi, Shah.

This is a Java question. You should apply a Custom Code step to your integration component. The input to the Custom Code step is the Broker Date object. The output is a String.

Within the Custom Code, do the transformation.

There has been other discussion on this topic. Please reference these other threads:

    [*][url="http://www.wmusers.com/wmusers/messages/120/490.shtml"]http://www.wmusers.com/wmusers/messages/120/490.shtml[/url] [*][url="http://www.wmusers.com/wmusers/messages/120/245.shtml"]http://www.wmusers.com/wmusers/messages/120/245.shtml[/url] [*][url="http://www.wmusers.com/wmusers/messages/120/595.shtml"]http://www.wmusers.com/wmusers/messages/120/595.shtml[/url] [*][url="http://www.wmusers.com/wmusers/messages/120/722.shtml"]http://www.wmusers.com/wmusers/messages/120/722.shtml[/url] [*][url="http://www.wmusers.com/wmusers/messages/120/759.shtml"]http://www.wmusers.com/wmusers/messages/120/759.shtml[/url] [/list]