Find no of days remaining on current month from given date
<p>I just want to calculate the number of days remaining from given date</p>

<p>Ex:</p>

<p>if the date is '02/01/2016' then the remaining days on the given month is '28'</p>

<p>if 03/05/2016 then '25' days...</p>

<p>I tried the below</p>

<pre><code>SELECT DATEPART(DD,'03/05/2016')  it given me only 5 days
</code></pre>