title: view behaviour with Datediff
body: <p>any idea why when i use this code </p>
  
  <pre><code>SELECT * FROM Runtime.dbo.AnalogHistory WHERE TagName = 'LT73011.Out_PV' 
  AND datediff(HOUR, DateTime, '2018-03-14 08:02:23.449') = 0
  </code></pre>
  
  <p>knowing that Runtime.dbo.AnalogHistory is my view 
  i get blank </p>
  
  <p>but when i query with this </p>
  
  <pre><code>SELECT * FROM Runtime.dbo.AnalogHistory WHERE TagName = 'LT73011.Out_PV' 
  AND DateTime &lt;= '2018-03-14 08:59:00.000'
  </code></pre>
  
  <p>i get all the values that happened at the hour 8am </p>
  
  <p>is there's a curtain restriction with a view? how can i work around this?</p>