DateFunction

[Rajesekhar]

What function can I use to convert date from Mon dd,yyyy to YYYY-MM-DD?

-Thanks
Raj

[ray.wurlod]

When's the interview?

This can't be done with a single function, you need a minimum of two. Which two will depend on the data types involved, information that you have not supplied.

Probably some combination of DateToString() and StringToDate(), with appropriate date format strings, will do it for you.

[Rajesekhar]

hahaha good one!!

but iam not appearing for any interview...

I am new to DataStage and trying out things...

Both input and output are of type Date.

Can you help me now?

[ray.wurlod]

Dates do not have formats. They are stored in a 32-bit structure in a binary format. Therefore your requirement is moot.

If you need to "translate" the dates from how they appear (as strings) in source and target, then you need to specify an appropriate format property in the stages that refer to them.