I have a table with two columns, id (varchar) and dtcol (datetime).
I'd like to count the number of rows between two dates. I've tried this as follows:
SELECT COUNT(id) FROM Table WHERE `dtcol` BETWEEN DATETIME '2008-10-10 11:45:00' AND '2008-10-10 10:45:00';
This gives me a syntax error. Please help me with the correct syntax!