Richard Teachout - My technobabble Blog - SQL code to get the last day of the month

KeywordsPhrase

Here are the most recent postings to this blog. Use the archive calendar or search to find other entries.

SQL code to get the last day of the month

Jun3

Written by:R Teachout
6/3/2007 10:07 PM

Great for queries where you need > date < date results..

Current Month:

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

DATEADD

(dd, - DATEPART(dd, GETDATE()), GETDATE())Previous Month:

Location: Blogs

Tags:

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:

Security Code Enter the code shown above in the box below
Add Comment Cancel

When the power of love overcomes the love of the power, the world will know peace.
-J. Hendrix