How to select records between a date to another date given a DateTime field in a table.
-
isn't it discussed/asked over here previously?Saar– Saar2009-12-22 11:16:46 +00:00Commented Dec 22, 2009 at 11:16
-
Look here: stackoverflow.com/questions/1443555/… Search rules! ;)ThinkJet– ThinkJet2009-12-22 15:37:26 +00:00Commented Dec 22, 2009 at 15:37
Add a comment
|
3 Answers
SELECT *
FROM tbl
WHERE myDate BETWEEN #date one# AND #date two#;
2 Comments
Richard
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.
ExpertWeblancer
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
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.
1 Comment
törzsmókus
PSA: xkcd.com/1179
select * from table name (exm.User) where column name (exm.Date) between '2022-10-10 08:00:00' and '2022- 10-11 12:00:00'
