title: How to get Year and Month of a DATE using Oracle
body: <p>How can I get the year and month of a date in the where clause using Oracle. </p>
  
  <p>I used to be working with SQL server and it was as simple as YEAR(FIELDNAME) and MONTH(FIELDNAME). </p>
  
  <p>I have tried the following:</p>
  
  <pre><code>SELECT * 
  FROM myschema.mytablename
  WHERE   EXTRACT(YEAR FROM  myDATE)  = 2017
  </code></pre>
  
  <p>however it gives ORA-30076 Error</p>