title: Postgresql query current year
body: <p>I need to see only the current year rows from a table.</p>
  
  <p>Would it be possible filter a timestamp column only by current year parameter, is there some function that can return this value?</p>
  
  <pre><code>SELECT * FROM mytable WHERE "MYDATE" LIKE CURRENT_YEAR
  </code></pre>