time

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
krisna
Participant
Posts: 77
Joined: Tue Apr 08, 2008 11:33 pm

time

Post by krisna »

Hi,

I have a column in a sequential file, where that column data is 101523 (10hrs 15mins 23secs) populating to oracle table column data type is date.

How to populate this data to oracle table as 10:15:23

Suggest some solutions.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What are you planning on using as the "date" portion of the timestamp you are writing to this DATE field? You will need one, btw. :?
-craig

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

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”