Exercise

First day of month

Here you will use the GETDATE(), DATEDIFF(), and DATEADD() functions to find the first day of the current month.

Instructions

100 XP

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.

Take Hint (-30 XP)