Between Dates e.g.

Blah blah WHERE MyDate Between @StartDate and @EndDate

Say i chose 11/5 to 11/25
I expect it to returns all records between the two dates but the time to be considered as well. Currently the query is check up until 11/25 12am omitting records written after 12am.

It should return all records from 11/5 12am THRU 11/25 11:59:59pm

Thanks