Written by:R Teachout
7/3/2008 1:30 AM

The logic behind this 'last day of the month' calculation is that you get the month part of a given date, add one to it to get to the next month. Then subtract 1 day from the first of that month.

This can be written in one line and here it is:

SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,GETDATE())),DATEADD(m,1,GETDATE())))

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel