mysql query to fetch records between the give times

The below is the mysql query to get records between the given times..

$now = date('H:i',time());

$time_restriction = "from_time <= '$now' and to_time >= '$now' ";
       
       
$sql = "SELECT  * FROM tblName WHERE $time_restriction ";