Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

SQL query to select dates between two dates

ayi

<t>SQL query to select dates between two dates</t>

ayi

<t>you should put those two dates between single quotes like..<br/>
<br/>

select Date, TotalAllowance from Calculation where EmployeeId = 1<br/>
             and Date between '2011/02/25' and '2011/02/27'<br/>
<br/>
```<br/>
<br/>
or can use<br/>
<br/>
```<br/>
select Date, TotalAllowance from Calculation where EmployeeId = 1<br/>
             and Date >= '2011/02/25' and Date <= '2011/02/27'<br/>
<br/>
```<br/>
<br/>
keep in mind that the first date is inclusive, but the second is exclusive, as it effectively is '2011/02/27 00:00:00'</t>