Selecting between two dates within a DateTime field - SQL Server

Question

How to select records between a date to another date given a DateTime field in a table.

Look here: http://stackoverflow.com/questions/1443555/sql-syntax-select-results-for-each-date-between-a-range-of-dates Search rules! ;) — ThinkJet, Dec 22 '09 at 15:37

score 28 · Accepted Answer · edited Dec 13 '15 at 07:30

28

SELECT * 
FROM tbl 
WHERE myDate BETWEEN #date one# AND #date two#;

edited Dec 13 '15 at 07:30

Shnugo

answered Dec 22 '09 at 11:14

Oded

2

between is terribly misunderstood. casting of dattime to date happens intentionally and unintentionally. Personally I like explicit >= and <= because it does not save much typing but is so much less readable. – Richard Nov 06 '19 at 03:37
SELECT * FROM bookings WHERE item_id=2884 AND (start_date BETWEEN '2020-09-05 23:31:45' AND '2020-09-06 00:00:00' OR end_date BETWEEN '2020-09-05 23:31:45' AND '2020-09-06 00:00:00') ) This is my code, but it doesnt work well – ExpertWeblancer Sep 05 '20 at 06:35

score 18 · Answer 2 · edited Dec 17 '15 at 15:09

18

select * 
from blah 
where DatetimeField between '22/02/2009 09:00:00.000' and '23/05/2009 10:30:00.000'

Depending on the country setting for the login, the month/day may need to be swapped around.

edited Dec 17 '15 at 15:09

Arulkumar

answered Dec 22 '09 at 11:15

Tikeb

2 Answers2