Date format in informatica

[InformaticaDW]

hello,

I want to know how to convert string data type format 'mmddyyyy' date column into string data type format 'ccyymmdd' type in informatica ?

Thanks,
Ram

 

[srvu]

You can use expression transformation to convert date into required format.

Use function TO_DATE(datefieldname,'format')

To_date(fieldname,'ccyymmdd')

 

[ArtieChoke]

You'll have to pull out the individual pieces and rearrange them or possibly convert them to date fields and reformat as show above.

"I think we're all Bozos on this bus!" - Firesign Theatre