title: oracle SYSDATE function not working in mybatis
body: <p>I am trying to use mybatis as ORM for Oracle SQL . 
  I have table called login_details which has "login_time" (Timestamp(6)) column which stores timestamp.</p>
  
  <p>Now I want such a records which were/are logged in  for more than 10 minutes.
  So I tried a query</p>
  
  <pre><code>   SELECT * FROM login_details WHERE username = 'abc' AND (SYSDATE - login_time) &gt; interval '10' MINUTE
  </code></pre>
  
  <p>which is working in DBVisualiser.
  I put this query in mybatis as follows </p>
  
  <p>
          SELECT * FROM login_details WHERE username = #{username} AND (SYSDATE - login_time) > interval '10' MINUTE
   </p>
  
  <p>it is not working when I put it into mybatis select tag as shown above.
  Instead of this , I tried </p>
  
  <pre><code> SELECT * FROM login_details WHERE (TO_DATE ('06/03/2015 23:45:34' , 'dd/MM/yyyy HH24:MI:SS') - login_time) &gt; interval '10' MINUTE
  </code></pre>
  
  <p>which works in mybatis.</p>
  
  <p>It seems mybatis has problem with SYSDATE</p>
  
  <p>please guide me to resolve this problem </p>