hi,
i have my date in DSJOBSTARTDATE
dslink2.effdate i was trying dslink2.effdate["2500-01-01 00:00:00.000"]
its giving me blank plz advice abt how i can trnasform it too
"2500-01-01 00:00:00.000"
Thanks
Bobby
Date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's not giving you blank, it's giving you zero-length string, because that's what you've asked it to do. Square brackets indicate substringing. Square brackets with a single number indicate rightmost characters. That you gave a string rather than a number will generate a "non-numeric where numeric required; zero used" warning in the job log. That zero has been used indicates that your expression is correctly extracting the right most zero characters from the data.
Do spend some time with the on-line help. Start with BASIC Tasks topic and drill down to your heart's content from there. In particular study about data formatting, and the Iconv and Oconv functions, and the "D" and "MT" conversion specifications.
This forum is not a substitute for reading manuals, nor for undertaking appropriate training. Nor, for that matter, for an English teacher.
Do spend some time with the on-line help. Start with BASIC Tasks topic and drill down to your heart's content from there. In particular study about data formatting, and the Iconv and Oconv functions, and the "D" and "MT" conversion specifications.
This forum is not a substitute for reading manuals, nor for undertaking appropriate training. Nor, for that matter, for an English teacher.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.