title: How do I get the current year using SQL on Oracle?
body: <p>I need to add the current year as a variable in an SQL statement, how can I retrieve the current year using SQL?</p>
  
  <p>i.e.</p>
  
  <pre>
    BETWEEN 
      TO_DATE('01/01/<i>**currentYear**</i> 00:00:00', 'DD/MM/YYYY HH24:MI:SS')
      AND
      TO_DATE('31/12/<i>**currentYear**</i> 23:59:59', 'DD/MM/YYYY HH24:MI:SS')
  </pre>