DSXchange

I need to convert the date in the parallel job version 8.5.

Input format : AUGUST 09, 2008
Output format : 2008-08-09

Is there any function to convert this date. Please help.

StringToDate() still works, check the documentation for the proper format mask. If your target is not a DATE then use DateToString() afterwards to get it back out in the format you need.

Try below

stringtodate(<<columnname>>,"%mmmm %dd,%yyyy")