Question: Write a sql query that follows these instructions Write a query that returns the first and last day of the month for any given date.
Write a sql query that follows these instructions
Write a query that returns the first and last day of the month for any given date. You should accomplish this with date functions
I will test a few random dates to make sure this works - make sure you test leap years, end of year, etc.
Your query should return two columns - one for the first day, one for the last. You can hard code the values into your query or use a variable (will show in class).
You cannot use the EOMonth function.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
