title: get value from table where date difference is more then certain value
body: <p>I have a table <code>EMPLOYEE_STATUS</code>, with column 
  <code>SUBMIT_DATE</code> values as <code>11-05-18 11:27:34.086000000 AM</code> 
  and <code>UPDATED_ON</code> values as <code>11-06-18 12:55:22.064000000 PM</code> 
  which is basically current date.</p>
  
  <p>I need a sql query for oracle database to find those rows where difference in days between submited date and updated on or current date is 30 days or more.
  I tried <code>DATEDIFF</code> function but couldnt able to make it work.</p>
  
  <p>I have tried the following (which does not work):</p>
  
  <pre><code>select * from EMPLOYEE_STATUS e 
  where DATEDIFF(month, '12-06-18 03:34:09.448000000 PM', e.SUBMIT_DATE) &gt;=1
  </code></pre>