title: How to add Floating(decimal) hour in DateTime's DATEADD function?
body: <p>I am trying to add some hours in SQL SERVER using DATEADD function. But when I try this,</p>
  
  <pre><code>SELECT DATEADD(Hour, 0.5, GETDATE()) 
  </code></pre>
  
  <p>It is not adding 0.5 hour. How to solve this?</p>