HI All,
How can we convert CHAR to TIMESTAMP In DATASTAGE SERVER JOBS.
CHAR to TIMESTAMP
Moderators: chulett, rschirm, roy
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
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