title: How to get the current last day for every month in DB 2
body: <p>i have multiple data date at table sql. In every date has date range for every month. i want to get the <strong>current last day for every month</strong> . How to do that?. Anyone know about this?.</p>
  
  <p>For example</p>
  
  <pre><code>daterange month             **current last day this month**
  
  ---------------------------------------------------------------
  
  2016-01-04                  2016-01-22
  2016-01-05                  2016-01-22
  2016-01-06                  2016-01-22
  2016-01-07                  2016-01-22
  2016-01-08                  2016-01-22
  2016-01-09                  2016-01-22
  2016-01-10                  2016-01-22
  2016-01-11                  2016-01-22
  2016-01-12                  2016-01-22
  2016-01-13                  2016-01-22
  2016-01-14                  2016-01-22
  ..........
  ..........
  ..........
  2016-01-22                  2016-01-22
  
  2016-02-02                  2016-02-25
  2016-02-03                  2016-02-25
  2016-02-04                  2016-02-25
  2016-02-05                  2016-02-25
  2016-02-06                  2016-02-25
  ..........
  ..........
  ..........
  2016-02-25                  2016-02-25
  
  2016-03-01                  2016-03-23
  2016-03-02                  2016-03-23
  2016-03-03                  2016-03-23
  2016-03-04                  2016-03-23
  2016-03-05                  2016-03-23
  2016-03-06                  2016-03-23
  ..........
  ..........
  ..........
  2016-03-23                  2016-03-23
  </code></pre>