SELECT * FROM MyTable WHERE CAST([date] as TIME) BETWEEN '01:00:00' AND '05:00:00'
SELECT * FROM MyTable WHERE TIME([date]) BETWEEN '01:00:00' AND '05:00:00'
SELECT DateField FROM TableName WHERE TIME(DateField) BETWEEN '01:00:00' AND '05:00:00'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)