date conversion

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
gayatri
Participant
Posts: 7
Joined: Tue Dec 12, 2006 11:08 am

date conversion

Post by gayatri »

Hi,

I am trying to load data into table.

source data for date is 1/1/2007
target table date format is 1-jan-07

how can i solve this.

Thanks
Top
kris18
Charter Member
Charter Member
Posts: 46
Joined: Mon Nov 13, 2006 9:53 am
Location: United States

Post by kris18 »

their are lot of posts regarding this topic search is what u need to do.



kris
kris
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

You can use ICONV/OCONV functions. Search for specific details or look into DataStage help.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Re: date conversion

Post by narasimha »

gayatri wrote:Hi,

I am trying to load data into table.

source data for date is 1/1/2007
target table date format is 1-jan-07

how can i solve this.

Thanks
What Databases are we talking about here
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”