Beginning of Month

Posted on December 5, 2009 by Derek Dieter
0
1

« Create Index on Table Variable

Get End of Month »

Possibly the easiest way to calculate the beginning of the month, is to use the DateAdd function and add a date difference of nothing to the month:

[cc lang=”sql”]
DECLARE @Date datetime
SET @Date = GETDATE()
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)
[/cc]

Post a comment

Featured Articles

How to cache stored procedure results using a hash key There are a lot of different design patterns that lend themselves to creating
SQL Server Database Optimization Guide In the troubleshooting guide we went over the different physical bottlenecks that can
Yet Another Temp Tables Vs Table Variables Article The debate whether to use temp tables or table variables is an old
Using Union Instead of OR Sometimes slow queries can be rectified by changing the query around a bit.

Site Author

Thanks for visiting!

Resources