title: Query to get current year from Amazon Redshift
body: <p>Trying to find the SQL query to get current year from Amazon redshift db.</p>
  <p>Tried following queries but didn't worked :</p>
  <pre><code>select DATE_PART_YEAR(SYSDATE);
  select DATE_PART_YEAR(getdate());
  </code></pre>