Using TimeDate

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
sumesh.abraham
Participant
Posts: 153
Joined: Thu May 11, 2006 1:52 am
Location: Bangalore

Using TimeDate

Post by sumesh.abraham »

Hi,

I used

Oconv(@DATE,'D-YMD'):Oconv(@TIME,'MTS') to populate the current datetime into the Oracle table. How can I achieve the same result using TimeDate function.

Thanks,
Sumesh
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Timedate output is in the form of "hh:mm:ss dd mmm yyyy", so separate the time and the date using Field, convert the date with an IConv/OConv pair and then glue the two pieces back together.
-craig

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

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