Instruction
Perfect! That's it for this part of the course. Let's have a short summary before we continue.
- To find rows for three weeks starting from March 20, 2017, use:
SELECT ... FROM ... WHERE ColumnName >= '20170320' AND ColumnName < DATEADD(Week, 3, '20170320')
- To find rows for the current month, use:
SELECT ... FROM ... WHERE ColumnName >= DATEADD(Month, DATEDIFF(Month, 0, GETDATE()), 0)
Okay, let's do a very short quiz before we conclude this part.
Exercise
Click to continue.



