title: Convert 01-Jun-2012 varchar to date
body: <p>I have a table where the dates (unfortunately) were brought in as varchar.  For example, I have a varchar date of 01-Jun-2012.  How do I convert this to yyyy-mm-dd format?  I have tried and failed with alter table, str_to_date and convert.  I am working in MySQL -Thank you! singh.rbir answered my issue, thank you! <a href="https://i.stack.imgur.com/NTrSv.png" rel="nofollow noreferrer">enter image description here</a></p>