title: How to convert MMYYYY (042011) to date and find datediff for todays date
body: <p>I have a <code>varchar</code> column with data like 042011 MMYYYY format. I want to convert this to find the gap from todays date to that column.</p>
  
  <p>I want a answer like 2.2 years or something related.</p>
  
  <p>I've tried</p>
  
  <pre><code>SELECT datediff(month,FORMAT(GETDATE(),'MM') + FORMAT(GETDATE(),'yyyy'),'042011')
  </code></pre>