yyMMdd to yyyyMMdd

[Former Member]

Hi Gurus,

I have no java background yet, and i have a simple requirement to convert source date format yyMMdd to target date format yyyyMMdd, do i need to create a UDF for this?

If Yes, can somebody give me the exact code for it?

Thank you in advance

[rodrigoalejandro_pertierr · Accepted solution]

Use DateTrans standar funtion under Date node in message Mapping, there provide the input parameter yyMMdd and the output parameter yyyyMMdd and the transformation is made.

Thanks

[Former Member]

Hi,

Under Functions tab -> Date -> Choose "DateTrans"(give ur input and output format) .

Thanks

Amit

[Former Member]

Just use the std DateTrans function. No need of udf.. in the DateTrans put your input and output format and then map it to target..