Answers for "sql server data between two dates"

SQL query to select data between two dates

SELECT * FROM  [table] 
WHERE [time] >='2014-04-08 23:53:00.000' AND [time] <= '2014-04-08 23:58:00.000'

SQL SERVER SELECT BETWEEN DATETIME

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