Tag Archives: date manipulation

First Day of Current Month

SELECT DATEADD( mm, DATEDIFF( mm, 0, GETDATE() ), 0 ) AS FirstOfMonth Since I always manage to get the syntax wrong from memory, above is a SELECT statement that will return the first day of the current month. Edit: As … Continue reading

Posted in SQL Toolbox | Tagged , , | 1 Comment