How do I query the DateTime database field within a certain range?
Error code below:
SELECT *
FROM TABLENAME
WHERE DateTime >= 12/04/2011 12:00:00 AM
AND DateTime <= 25/05/2011 3:53:04 AM
Note: I am using SQL SERVER 2005 and I want to get rows within a certain time range. For example, 10 mins time range.
Can someone please help me with this?