title: How can I convert a varchar into a date in MySQL Workbench?
body: <p>Probably it's super simple but i've been stuck some hours on this.
  I have a column called &quot;Publish_Date&quot; which is a varchar, but my date shows like this: 17.01.11 (year.day.month) and I want to convert it to a date (at this point, any date format it's ok).</p>
  <p>Every time i tried to use &quot;convert&quot; or &quot;cast&quot; it gives me a syntax error or the data doesn't change or all the data in the column changes to &quot;null&quot; values.
  I'd appreciate if you can help me.</p>