title: Convert varchar column to date type
body: <p>I have a table as follows:</p>
  <pre><code>Player    Runs    Date
  AA        100     01-jan-2010
  AB        130     02-jan-2010
  AC        150     01-jan-2010
  AA        170     03-jan-2010
  AB        100     01-feb-2010
  AC        90      05-jan-2010
  AA        10      10-jan-2010
  AA        100     02-feb-2010
  AB        100     01-feb-2010
  AC        100     04-jan-2010
  </code></pre>
  <p>The date is of varchar type. I want to calculate which player scored the most runs in the month of January. I'm facing issues as I'm not able to convert the varchar to date type hence couldn't use any date functions of SQL</p>