- date_interval_create_from_date_string: documentation ( source)
- date: documentation ( source)
- strtotime: 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"));
$between = " AND BETWEEN " . date("Y-m-d H:i:s", strtotime($queuedTime15)) . " AND " . date("Y-m-d H:i:s", strtotime($queuedTime));
echo $between;
?>