- date_interval_create_from_date_string: documentation ( source)
- date_sub: documentation ( source)
<?php
$queuedTime = "2011-03-17 06:42:10";
$b2 = new DateTime($queuedTime);
$b1 = date_sub($queuedTime,date_interval_create_from_date_string("100 minutes"));
$b1 = $b1->format("Y-m-d H:i:s");
$between = " AND BETWEEN " . $b1 . " AND " . $b2;
echo $between;
?>