title: Convert ODBC Canonical date to binary, or using a ODBC Canonical function
body: <p>I have a query where I am trying to pull information where the firstdate is less than the seconddate, however most date times are pretty close to each other, so I tried:</p>
  
  <pre><code>select id from entries where firstdate [less than] seconddate -2000000000 
  </code></pre>
  
  <p>However it doesn't seem to provide the information I would like. I have two thoughts:</p>
  
  <ol>
  <li>I could convert the ODBC Canonical dates to binary so I can use a variable like in the example above.</li>
  <li>Use a ODBC Canonical function where I could simply state that the second date is at least 10 days behind.</li>
  </ol>