title: How to subtract 18 hours from SYSDATETIME()
body: <p>Trying to get a day and 1/2 less than the current time. In Oracle this works fine, however I get an error when doing this in Microsoft. </p>
  
  <p>Here is my code:</p>
  
  <pre><code>and dataDate.DateValue &gt; SYSDATETIME() - 1.5
  </code></pre>
  
  <p>my error:</p>
  
  <pre><code>Operand type clash: datetime2 is incompatible with numeric
  </code></pre>