Date conversion

kmoorer · Post by **kmoorer** » Mon Aug 08, 2011 1:59 pm

I have a date coming in format "Tuesday, June 07, 2011".
How can I convert this to yyyy-mm-dd format.
I looked at DateToString, but it looks like it has to be in numeric format.
I can't use Iconv/Oconv becase it's a parallel job.
I could disect the date, remove the day, convert June to 06...
But if there is a better way I would sure like to know.

jwiles · Post by **jwiles** » Mon Aug 08, 2011 2:13 pm

DateToString() would likely not be the correct function as it's expecting a value that is already in a Date column. It sounds like your date is coming in as a string, so maybe StringToDate() would be the first step?

Two more important questions:
- What is your source data type and your target data type?
- Have you searched for "date formats" in the Parallel Job Developer Guide? Quite a few options listed there that should be able to cover your date's format.

Regards,

arunkumarmm · Post by **arunkumarmm** » Mon Aug 08, 2011 2:16 pm

Is it not possible for you to use a BASIC transformer and make use of IConv/OConv?