title: Need to calculate date difference of today date vs converted date field
body: <p>I have a table with a column that was previously converted using</p>
  
  <pre><code>(CONVERT(VARCHAR(19), GETDATE(), 112)
  </code></pre>
  
  <p>With the getdate being the date when the field was inserted. Now I have to compare the current date against the date the field was inserted.
  The issue I'm facing is that when the date field is from last month, say 20131004, I calculate date difference by (CONVERT(VARCHAR(19), GETDATE(), 112) - 20131004, the result is 200. Obviously this is wrong...
  Could you please suggest me how I could calculate the true date difference?</p>