sql - SQL查询以选择两个日期之间的日期(SQL query to select dates between two dates)

Question

I have a start_date and end_date .

(我有一个start_date和end_date 。)

I want to get the list of dates in between these two dates.

(我想获取这两个日期之间的日期列表。)

Can anyone help me pointing 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.

(Date是一个datetime变量。)

  ask by Neeraj translate from so

Answer 1

you should put those two dates between single quotes like..

(您应该将这两个日期放在单引号之间，例如。)

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

or can use

(或可以使用)

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