First day of month
Here you will use the GETDATE(), DATEDIFF(), and DATEADD() functions to find the first day of the current month.
Latihan ini merupakan bagian dari kursus
Writing Functions and Stored Procedures in SQL Server
Instruksi latihan
- 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.
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
-- Find the first day of the current month
SELECT ___(___, ___(___, 0, GETDATE()), ___)