Converting string to date

[#1]

hi,

i am loading data from SQL and the date format is in varchar and is looking like this 16AUG2016 , i am needing to convert it to date but i am batlling,

16AUG2016

26MAR2015

28AUG2015

03MAY2017

26MAR2015

26MAR2015

26MAR2015

09MAR2017

26MAR2015

13JAN2017

26MAR2015

can anybody assist please

regards,

marvin

[madhuqliklondon]

Hi,

may be this

LOAD

Date(Date#(PIS_DATE,'DDMMMYYYY:hh:mm:ss'),'DD-MM-YYYY') As PIS_DATE

FROM

..............

[prma7799 · Accepted solution]

PFA....

[prma7799]

Did you get right answer?

[#5]

hi,

Thanks perfect it worked, now just to create the mast calendar for this model.

[prma7799]

I think you marked wrong reply for correct answer ...

[#7]

sorted ... sorry