type conversionin transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

type conversionin transformer

Post by kennyapril »

I have an input which is exp_dt (expiryDate)

can any one help me with the type conversion for changing the date to string

I see type conversion in transformer but cannot fill the details
DateToString(%date%[%"%yyyy-%mm-%dd"%])
Regards,
Kenny
vinothkumar
Participant
Posts: 342
Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India

Post by vinothkumar »

Search for this function in help.. You will be able to find. Also this has been posted here several times :)
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Code: Select all

DateToString(InputDateField,"%yyyy-%mm-%dd")
You are the creator of your destiny - Swami Vivekananda
Post Reply