sql get the first day of a month code example Example: sql server beginning of month SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS StartOfMonth