Date Conversion

Pk39565 · Post by **Pk39565** » Mon Feb 18, 2008 9:06 am

I wanted to convert the date 2008-01-21 23:59:59 into 2008-01-21
in datastage server edition.

Thanks in advance

ArndW · Post by **ArndW** » Mon Feb 18, 2008 9:27 am

In.DateColumn[1,10]

should do the trick.

Pk39565 · Post by **Pk39565** » Mon Feb 18, 2008 9:47 am

Ur asking me take substring...

I have done with substring but it's not working.

kcbland · Post by **kcbland** » Mon Feb 18, 2008 10:00 am

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.

chulett · Post by **chulett** » Mon Feb 18, 2008 10:11 am

What is not working about it? The substring operator as posted will do exactly as you said you needed.

ArndW · Post by **ArndW** » Mon Feb 18, 2008 11:45 am

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.