Richard Teachout - My technobabble Blog

KeywordsPhrase

	View All Recent Entries
	Great Websites to Visit!
	Linux - PBX (asterisk/freepbx)
	Linux Stuff
	MS Virtual Server
	MSSQL Scriptlets
	Ramblings
	VBS / Administration Scriptlets
	Webmin Blog
	Windows & IIS stuff

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

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:
Title:
Comment:

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

Treat your password like your toothbrush. Don't let anybody else use it, and get a new one every six months.
-Clifford Stoll