Simple thing you can do is to use TRIM function to remove those '-'.
Trim(CYC_DT,"-","A").
and further to if you want same with the NULL handling then,
If IsNull(CYC_DT) Then "NULL" Else Trim(CYC_DT,"-","A")
Use Stage Variable.
Search found 1 match
- Mon Aug 01, 2011 4:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting date
- Replies: 13
- Views: 5950