MSQL parse dates as 21-JUN-14

Vote count:

0

I have some dates exported as varchars from an Oracle database, and the dates are in this format;

20-JAN-13

14-OCT-14 etc etc

How can I parse them? I've been trying things such as STR_TO_DATE(next_event_date, '%d-%mmm-%YY') but no luck, any ideas?

Kind Regards, Harry

asked 37 secs ago

Harry Torry

133