title: when i subtract 8 hours from a date it should change the date in sql
body: <p>i want to consider only 8 hours in a day. means when i add 8 hours to one day it should change the date automatically.</p>
  
  <p>Example : </p>
  
  <pre><code>2015-05-24 00:00:00.000 + 8 hours = 2015-05-25 00:00:00:00
  </code></pre>
  
  <p>Is it possible to it in sql</p>