Beginning 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]

Featured Articles

 Site Author

  • Thanks for visiting!