Date Conversion in oci stage

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
Pk39565
Premium Member
Premium Member
Posts: 34
Joined: Tue Dec 25, 2007 12:03 am
Location: Brisbane

Date Conversion in oci stage

Post by Pk39565 »

I am selecting date column from a table in OCI stage and putting into sequential file. but in sequential file dat is not showing in proper format.

I have tried with to_char for date column while selecting but it's not showing in proper format. can anyone please help me?
Praneet
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

First we'd have to have some clue what you consider "proper format" to be. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

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