title: Difference between two dates not considering the year in Oracle SQL
body: <p>I would like to ask about the difference between two dates and its not consider the year for check the birthday. I find the query to check the two dates and its consider the year.</p>
  
  <p>For example, </p>
  
  <pre><code>   SELECT to_date(SYSDATE,'DD-MM-YYYY') - to_date(dateofbirth,'DD-MM-YYYY')
     FROM employees;
  </code></pre>
  
  <p>Thanks in advance..</p>