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
rockr
Participant
Posts: 17
Joined: Thu Feb 01, 2007 3:56 pm

Post by rockr »

THANKS GUYS!!

DSGURU's Derivation worked like a charm !

Marking as resolved !
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

rockr - timestamp contains a time component. If your data doesn't have it you will need to add it, as DSGuru2B has already shown.
Top
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Post by sud »

DSguru2B wrote:Try the following

Code: Select all

StringToTimestamp(TRIM(INPUTCOL):"000000","%yyyy%mm%dd%hh%nn%ss")
That is your input mask :wink:
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
Top
rockr
Participant
Posts: 17
Joined: Thu Feb 01, 2007 3:56 pm

Post by rockr »

thanks for the clarification guys ! :)
Top
Post Reply

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