DSXchange

I have a date field coming in from DB2 in the format DD-MM-YYYY. I want to use it in a date function that needs it in the format YYYY-MM-DD. What's the easiest way to do the switch? Can do it in a modify stage or a transformer. Needs to handle one or two digit days and months.

Force the leading zeroes (Derivation) when extracting. Then you should be able to nest string_from_date in date_from_string in a Modify stage.

Hi Guys,

Can't we break the input date DD-MM-YYYY into three subparts i.e DD,MM,YYYY and then combine them together in the required order YYYY-MM-DD?

Thanks,
Naveen

Only if its data type is string. If its data type is date, you must first convert to string (string_from_date in Modify stage would do). Only string data types (including ustring) support substring operations.

Hi Ray,

Thanks for the usefull information. Like always "Ray is the Best". :D

Thanks,
Naveen