如何选择特定时间跨度的记录？

I want to select the records from table that lies in between a specific time span. for example select record_name from tbl_name where date (is between now and 10 minutes earlier)? hope this rough query will explain my questionI want to select the records from table that li