title: Difference between two date& time in datetime Fields in SQL
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/9521434/how-to-compare-two-dates-to-find-time-difference-in-sql-server-2005-date-manipu">How to compare two dates to find time difference in SQL Server 2005, date manipulation</a>  </p>
  </blockquote>
  
  
  
  <p>I had two datetime fields and should calculate the between them including time fields.</p>
  
  <p>If the difference between them is less than 24 hours it should consider as 1 day and 24 to 48 hours as 2 days.</p>