I would like to run a query that gives me the data from March 1st to March 20th but only between the hour of 11:00 pm to 12:30 AM
field: fieldAB which is datetime ie 2011-01-07 10:03:27.000 2011-01-07 00:23:20.000
so something like this
select * from tbl1 where fieldAB between '2011-03-01' and '2011-03-20'
and fieldAB '11:00' and '00:30'