Get startedGet started for free

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

View Course

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()), ___)
Edit and Run Code