Published on September 6, 2016 by abundantcode
Filed under SQL Server
Last modified September 6, 2016
This article have been viewed 2768 times
If you want to get the first day of the month of a input datetime variable from a SQL Query , here’s how you do it.
SELECT DATEADD(month, DATEDIFF(month, 0, GetDate()), 0) AS StartMonthDate
databaseHow toSQL Servertipstricks
Notify me of follow-up comments by email.
Notify me of new posts by email.