title: How to minus date from sysdate using oracle inline query?
body: <p>I am creating one query. In that query i want minus date from system date. My table is like below.</p>
  
  <pre><code>Table Name : Employee
  ---------------------
  ID
  NAME
  JOINDATE
  </code></pre>
  
  <p>I am writing this query to fetch my result</p>
  
  <pre><code>SELECT * FROM SS.EMPLOYEE WHERE (sysdate - JOINDATE)='05-Ded-11'
  </code></pre>
  
  <p>This throws the following error: </p>
  
  <pre><code>SQL Error: ORA-00920: invalid relational operator
  </code></pre>
  
  <p>So how to do this???If anyone knows than please help me.</p>