title: Compare datetime in android sqlite
body: <p>I have this statement :</p>
  
  <pre><code>SELECT t1.* FROM pos t1
          INNER JOIN pos_visit t2
             ON t2.pos_id = t1.id_pos
          INNER JOIN roadmap t3
             ON t3.id_roadmap = t2.roadmap_id
  WHERE t3.id_roadmap ='rmp100000000000000020121206114347690'
      AND datetime(t1.lastChangedDate) &gt; datetime(t3.lastChangedDate);
  </code></pre>
  
  <p>and I get no such a function  <code>datetime</code>.</p>
  
  <p>I mention that I tried <code>strftime</code> too. All this functions works fine on sqLiteBrowser, but in Android, it is not working. I tried <code>julianday</code> and I don't get any error, but the Select is not returning the correct values (it should return one registration and it does not return anything)</p>
  
  <p>Any idea where is the problem ?</p>