title: using relative dates in select query
body: <p>I'm trying to use relative dates in my query. From searching I've seen two ways of doing this (sure there are more) but neither work for me and I can see data in my table for 2016-06-14</p>
  
  <pre><code>select * from tblMy where DatePrice = GETDATE() - 1
  
  select * from tblMy where DatePrice = DATEADD(DAY, -1, GETDATE())
  </code></pre>