Date type conversion

vasam · Post by **vasam** » Wed Sep 15, 2010 4:37 am

How do i convert date 2010-May-12 to 12-05-10?

I am using Parallel extender.

Any suggesion pls?

chulett · Post by **chulett** » Wed Sep 15, 2010 6:34 am

StringToDate() followed by DateToString() using an appropriate format mask in both cases. Don't have access to my reference materials but off the top of my pointy little head, %yyyy-%mmm-%dd and %yy-%mm-%dd respectively?

routhu · Post by **routhu** » Wed Sep 15, 2010 7:58 am

chulett wrote:StringToDate() followed by DateToString() using an appropriate format mask in both cases. Don't have access to my reference materials but off the top of my pointy little head, %yyyy-%mmm-%dd and %yy-%mm-%dd respectively?

criag,

we can do the same using oconv and iconv functions too rite??

priyadarshikunal · Post by **priyadarshikunal** » Wed Sep 15, 2010 8:03 am

As OP is using enterprise edition, iconv and oconv is not recomended (however can be used in a basic transformer). Craig has suggested the appropriate solution.