First day of month
Here you will use the GETDATE()
, DATEDIFF()
, and DATEADD()
functions to find the first day of the current month.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Find the current date value.
- Calculate the difference in months between today and
0
(1/1/1900
in SQL). - Add 0 months to that difference to get the first day of the month.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Find the first day of the current month
SELECT ___(___, ___(___, 0, GETDATE()), ___)