SQL query to select dates between two dates

774 Asked by Rahulverma in SQL Server , Asked on Mar 17, 2021

I have a start_date and end_date. I want to get the list of dates in between these two dates. Would anyone like to help me pointing out the mistake in my query.?

select Date,TotalAllowance
from Calculation
where EmployeeId=1
and Date between 2011/02/25 and 2011/02/27

Here Date is a datetime variable.

Answered by Puja Khatri

SQL query to select dates between two dates

Your Answer