Revisions to SQL query to select dates between two dates

The answer was unclear and misleading with regards to the second date

Source Link

edit approved Dec 20, 2019 at 19:55

581
6
12

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'

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

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'

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'

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

Changed the ">" and "<" to ">=" and "<=" to make it inclusive like the "between" operator in the example above it. Also added spaces for readability.

Source Link

edit approved Jul 30, 2014 at 20:17

Community Bot

1
1

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

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

or can use

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

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'

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'

coding tags

Source Link

edit approved Feb 26, 2011 at 4:59

stefan

2.9k
23
27

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 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'

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

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'

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'

Source Link

answered Feb 26, 2011 at 4:37

Deepak

8k
3
26
26

Loading

Collectives™ on Stack Overflow

Return to Answer