UTC Time stamp to Oracle Time stamp

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
shiva.chidara
Participant
Posts: 8
Joined: Sat Jan 28, 2006 7:53 pm

UTC Time stamp to Oracle Time stamp

Post by shiva.chidara »

Hi all,

How to convert UTC time stamp(for example '2016-08-10T18:27:23.3270000Z') to valid Oracle time stamp ??

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

Post by chulett »

What have you tried? What kind of Oracle "timestamp" are we talking about, there are at least three from what I recall... can you post the actual, full data type from the table? Just want to confirm what you're dealing with...
-craig

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