First day of month
Here you will use the GETDATE(), DATEDIFF(), and DATEADD() functions to find the first day of the current month.
Bu egzersiz, kursun bir parçasıdır
Writing Functions and Stored Procedures in SQL Server
Egzersiz talimatları
- Find the current date value.
- Calculate the difference in months between today and
0(1/1/1900in SQL). - Add 0 months to that difference to get the first day of the month.
Uygulamalı etkileşimli egzersiz
Bu egzersizi bu örnek kodu tamamlayarak deneyin.
-- Find the first day of the current month
SELECT ___(___, ___(___, 0, GETDATE()), ___)