title: Calculating number of days between a date and today in SQL Server?
body: <p>I want to calculate number of days from a date. </p>
  
  <p>For example, we have <code>@date='03/16/2012'</code>. I want to get number of days up to now.</p>
  
  <p>How can I do it?</p>