m-u
1/29/2014 - 4:51 PM

Get records between two 2 dates

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)