I wanted to convert the date 2008-01-21 23:59:59 into 2008-01-21
in datastage server edition.
Thanks in advance
Date Conversion
Moderators: chulett, rschirm, roy
Date Conversion
Praneet
Code: Select all
In.DateColumn[1,10]
If there is an error message, please post it. If not, please write output to a Sequential file stage and look at the result there. I suggest you write a column of the source data as-is and another column of the date using the substring notation.
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
I think I answered your question, but not your problem. It would seem that the column does not contain what you think. Is it a string or do you use OCONV() somewhere? If you were to post the problem and result you will get an answer, otherwise nobody here will be able to guess what is happening with your data on your machine.