title: SQL query to find last day of current month?
body: <pre><code>SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
   LastDay_CurrentMonth
  </code></pre>
  
  <p>Hi everyone I have a query to find the last day of current month, which is surely working well, but I am unable to understand it, because I have other similar requirements and have to change it accordingly.</p>
  
  <p>Can somebody explain it to me..
  Thanks in advance</p>