title: Informix datetime: How to subtract 15 Minutes
body: <p>How can I do this MySQL statement in an IBM Informix?</p>
  
  <pre><code>select type, channel, teilnr, starttime, endtime, usedtime, host 
  from online_time 
  where starttime &lt; DATE_SUB(NOW(),INTERVAL 15 MINUTE)
  order by starttime desc 
  </code></pre>
  
  <p>I tried this one in Informix, but it gave a syntax error. </p>
  
  <pre><code>select type, channel, teilnr, starttime, endtime, usedtime, host 
  from online_time 
  where starttime &lt; subdate(CURRENT, INTERVAL "15" MINUTES)
  order by starttime desc 
  </code></pre>