Get records between two 2 dates
SELECT * FROM TABLE where datetime >= Convert(datetime, '2014-01-17 00:00:01', 120) AND datetime <= Convert(datetime, '2014-01-17 23:59:01', 120)