Integer to Date

diamondabhi · Post by **diamondabhi** » Thu Dec 07, 2006 1:36 pm

I have an integer source(AS400) field which I need to convert into DB2UDB date field.
The value of the field is like this 060526(yymmdd). Please let me know the best way to do it.

Thanks in advance.
Abhi.

DSguru2B · Post by **DSguru2B** » Thu Dec 07, 2006 1:41 pm

How about this?

Nageshsunkoji · Post by **Nageshsunkoji** » Thu Dec 07, 2006 5:47 pm

Hi,

First put your integer in a string field in a stage variable and convert that function into date by using StringToDate function as in the link suggested by Dsguru2B.