title: Trying to fetch records older than 30 days in oracle sql
body: <p>I am trying to fetch the records in Oracle sql which is older than 30 days (from Mod_date) and I am using the below query and it is returning all the data and I want only 30 days old data. Will you please anyone help me to correct this query Sample :- Mod_date 03-NOV-12 12.00.00.000000000 AM  Query :-  </p>
  
  <pre><code>select Mod_date 
  from fil_cnfact 
  where Mod_date &lt;= sysdate -30 
  order by Mod_date asc ;
  </code></pre>