How to covert string to timestamp in millisecond

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
svipul16
Participant
Posts: 8
Joined: Sun Sep 23, 2007 10:29 am

How to covert string to timestamp in millisecond

Post by svipul16 »

Input data is string .I want to convert it to timestamp(26,6) with format YYYY-MM-DD-hh:mm:ss.nnnnnn.How would i get that?

I tried using convert to timestamp function,but its not working.Is there any function or routine for that?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Search the forums for "milliseconds", this has been asked and answered before. Never mind the fact that it is documented for the StringToTimestamp() function.
-craig

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