DevPinoy.org
A Filipino Developers Community
Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Groups
DevCast
Keith Rull
»
All Tags
»
Snippets
(
RSS
)
Browse by Tags
Keith Rull
Home
About
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Some useful date processing SQL Snippets
Tags
.NET
.NET How To's
ASP.NET
Blog News Node
C#
Contest
Events
Filipino Developer
Filipino Podcast
Filipino Programmer
Geek Fun
Generics
GridView
How To
Java
LINQ
My .Net Exploits
Pinoy
Pinoy Podcast
Pinoy Programmer
Site News
SQL
SQL Playbook
Tutorial
Your Career
View more
News
Badges
Archives
January 2009 (1)
November 2008 (1)
October 2008 (4)
September 2008 (8)
August 2008 (4)
July 2008 (2)
June 2008 (8)
April 2008 (4)
March 2008 (8)
February 2008 (8)
January 2008 (9)
December 2007 (9)
November 2007 (23)
October 2007 (3)
September 2007 (5)
August 2007 (5)
July 2007 (1)
June 2007 (3)
May 2007 (11)
April 2007 (1)
March 2007 (9)
February 2007 (8)
January 2007 (2)
December 2006 (2)
November 2006 (1)
October 2006 (8)
September 2006 (9)
August 2006 (5)
July 2006 (1)
June 2006 (10)
May 2006 (10)
April 2006 (11)
March 2006 (9)
February 2006 (20)
January 2006 (17)
December 2005 (7)
November 2005 (1)
October 2005 (4)
September 2005 (4)
August 2005 (4)
July 2005 (4)
June 2005 (4)
March 2005 (3)
Date Processing
SQL
SQL Server
Useful SQL Scripts
Some useful date processing SQL Snippets
Here's an update to my blog entry 3 years ago regarding the same topic: ---Calculates the first day of the previous month SELECT DATEADD (mm, DATEDIFF (m, 0, GETDATE ()) - 1, 0) AS [First day of the previous month ] ---Calculates the first day of...
Published
07-24-2008 11:44 AM
by
keithrull
Filed under:
SQL
,
SQL Server
,
Date Processing
,
Snippets
,
Useful SQL Scripts
Copyright DevPinoy 2005-2008