select * from your_table where '01/13/2011' between startdate and enddate

OR

select * from your_table where '01/13/2011' between CONVERT(VARCHAR(10), startdate, 101) AND CONVERT(VARCHAR(10), enddate, 101)

这应该做到-

This should do it -

select * from mytable where startdate <= @myDate and enddate >= @mydate