How to find last date of current year in db2
<p>I want to find the last date for current year. As of now i am doing it like below and it is giving me right result '2016-12-31'. but i want to know is there any possible function to do this -</p>

<pre><code>SELECT date(substr(current_date,1, 4)||'-'|| '12-31')  FROM SYSIBM.SYSDUMMY1
</code></pre>