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