Online PHP editor | refs for X011N

<?php $now = new DateTime(); $now->setTimezone(new DateTimeZone("UTC")); $new_time = strtotime($now->format('Y-m-d H:i:s -12 hours')); $query = "(SELECT * " . "FROM quote q " . "WHERE q.updated_at = 0 AND q.created_at between '" . date('Y-m-d H:i:s', $new_time) . "' AND '" . $now->format('Y-m-d H:i:s') . "') UNION (SELECT * FROM quote k WHERE k.updated_at != 0 AND k.updated_at BETWEEN '" . date('Y-m-d H:i:s', $new_time) . "' AND '" . $now->format('Y-m-d H:i:s') ."')"; echo $query;