date formats in Paralle extender

nair · Post by **nair** » Tue Nov 15, 2005 1:10 pm

Hello Everybody,
I want to know how to convert the date formats in parallel.
I know in server, we use ICONV and OCONV.
I have to convert source format 1/1/2005 to 20050101 format.

Please let me know how to do in paralle.

Thanks in Advance
nair

jenkinsrob · Post by **jenkinsrob** » Tue Nov 15, 2005 5:39 pm

What is you source??

You can either read the date as a string and chop out the /'s and rearrange to the YYYYMMDD format. Then use StringToDate(<YourDate>,'%yyyy%mm%dd') to get it into a date datatype

Or

Do DateToString() Then Rearrange Then do StringToDate()

vmcburney · Post by **vmcburney** » Tue Nov 15, 2005 6:00 pm

You can do it in a transformer, use the right mouse click menu to find a list of functions, you can do it a bit more quickly in a Modify stage. Use the Parallel Job Developers Guide to find a list of functions valid for a Modify stage spec. Note that the functions used by the Modify stage are different to those used by a Transformer.