Date conversion

suja.somu · Post by **suja.somu** » Thu Jan 30, 2014 9:22 am

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.

chulett · Post by **chulett** » Thu Jan 30, 2014 10:32 am

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.

srinivas.g · Post by **srinivas.g** » Thu Jan 30, 2014 11:29 am

Try below

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