title: How to get last 90 days data from today
body: <p>I am trying to get last 90 days data from today — is there any function in Informix to do that?</p>
  
  <p>Like in other SQL:</p>
  
  <pre><code>Select * from table1 where DATEADD(d,-90,getdate())
  </code></pre>