char to timestamp

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
Marley777
Premium Member
Premium Member
Posts: 316
Joined: Tue Jan 27, 2004 3:26 pm

char to timestamp

Post by Marley777 »

Hi how can I convert this character input field to a timestamp field that includes mileseconds? Also not sure if the periods will cause issues?

1993-03-25-23.47.38.423420

Thanks for your help.
Marley777
Premium Member
Premium Member
Posts: 316
Joined: Tue Jan 27, 2004 3:26 pm

Post by Marley777 »

I answered my oqn question

StringToTimestamp(myfield,"%yyyy-%mm-%dd-%hh.%nn.%ss.6")
jonamg
Participant
Posts: 10
Joined: Wed Feb 23, 2005 11:29 am

Post by jonamg »

You convert using a in bulit function called StringToTimestamp() in the Transformer.
Post Reply