How to convert the date from MM/DD/YYYY TO DD/MONTH/YYYY

[Kohli]

8/3/2013

8/2/2013

8/1/2013

8/1/2013

7/31/2013

7/31/2013

I want output like:

03/Aug/2013

02/Aug/2013

01/Aug/2013

31/Jul/2103

etc...

[kenphamvn]

Hi

Try This

date('8/3/2013','DD/MMM/YYYY')

Regards

An Pham

[techvarun]

Use Below line to achieve the result.

Date(Date#(Date,'MM/DD/YYYY'),'DD-MMM-YYYY')

LOAD *,Date(Date#(Date,'MM/DD/YYYY'),'DD-MMM-YYYY') as NewDate INLINE [
    Date
    8/3/2013
    8/2/2013
    8/1/2013
    8/1/2013
    7/31/2013
    7/31/2013
];

HTH

Varun