oracle8.1.6 and s.completed_datetime >= $start_time and trunc(s.completed_datetime) <= $end_time