title: Cast Date in Informix
body: <p>I have never used Informix before and I'm trying to write a query that will return records over the last 365 days.</p>
  
  <p>Here is the query I have been trying to use:</p>
  
  <pre><code>Select * from Visit where vis_mod_dt between today-365 and today;
  </code></pre>
  
  <p>That returns no records even though I know that there is data for the last 365 days.  I am guessing that the vis_mod_dt in not a true date column, although it displays as '12/31/1899'  I have tried to cast this column using:</p>
  
  <pre><code>select * from visit where date(vis_mod_dt) between today-365 and today;
  </code></pre>
  
  <p>This still returns no data.</p>
  
  <p>Any ideas?</p>