CHAR to TIMESTAMP

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sankar.td
Participant
Posts: 42
Joined: Fri Jul 25, 2008 3:53 am
Location: pune
Contact:
Contact sankar.td

CHAR to TIMESTAMP

Post by sankar.td »

HI All,


How can we convert CHAR to TIMESTAMP In DATASTAGE SERVER JOBS.
sa
Top
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Contact kcbland

Post by kcbland »

Make sure your CHAR data looks like a TIMESTAMP, if not reformat it to look like a TIMESTAMP. If loading into a database make sure generated SQL correctly casts (like with a TO_DATE) else write your own.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”