title: sql date time format in search gives different results
body: <p>I ran a query in which I wanted to find all of the orders that were made starting June 1. Originally I used this code:</p>
  
  <pre><code>select blah blah
  Where ORDERS.ORDER_DATE &gt; '2016-05-31 23:59:59.999'
  </code></pre>
  
  <p>But the query failed to select orders made on June 1. When I changed the code:</p>
  
  <pre><code>Where ORDERS.ORDER_DATE &gt; '2016-05-31 23:59:59.99'
  </code></pre>
  
  <p>I got the June 1 orders. The difference is the  <code>_2_ nines (.99)</code> on the end versus <code>_3_ nines (.999</code>) in the fractions of seconds. The data always shows 3 figures in the fractions. (Our data only has shows zeros in the fractions of seconds <code>"XX:XX:XX.000"</code>)</p>
  
  <p>What is going on here? </p>