title: How to extract year from HIRE_DATE in my sql
body: <p>I've written this </p>
  
  <pre><code>SELECT last_name from EMPLOYEES where year(HIRE_DATE)='2000';
  </code></pre>
  
  <p>but it shows "invalid identifier year".</p>