How can I select the first day of a month in SQL? September 22, 2022 by Tarik SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS StartOfMonth