SQL查询以选择两个日期之间的日期 [英] SQL query to select dates between two dates

问题描述

我有一个开始日期和结束日期。我想获取这两个日期之间的日期列表。谁能帮助我指出查询中的错误。

I have a start_date and 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

这里的 Date 是一个 datetime 变量。

推荐答案

您应该将这两个日期放在单引号之间。

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'

或可以使用

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

保持请记住，第一个日期是包含日期，但第二个日期是排除日期，因为它实际上是'2011/02/27 00:00:00'

keep in mind that the first date is inclusive, but the second is exclusive, as it effectively is '2011/02/27 00:00:00'

这篇关于SQL查询以选择两个日期之间的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！