title: Select the first day and last day of this year in DB2
body: <p>How to get the first day and the last day for the current year in DB2 in format YYYYMMDD?</p>
  
  <p>I tried:</p>
  
  <pre><code>SELECT SUBSTR(CHAR(CURRENT DATE),8,0)||'0101' 
  </code></pre>
  
  <p>And:</p>
  
  <pre><code>SELECT SUBSTR(CHAR(CURRENT DATE),8,0)||'1231
  </code></pre>
  
  <p>But it does not work till I put the year, but I need the year to be a parameter "not need to change it every year in the Query"</p>