cakephp saving dates in datetime format code example
Example: Add 2 hours to current time in cakephp
DATE_ADD(MemberBookFacility.time, INTERVAL 1 hour) <= '
if (isset($data_search["time_start"]) && !empty(trim($data_search["time_start"]))) {
$conditions['TIME(MemberBookFacility.time) >= '] = $data_search["time_start"]; // date('H:i', strtotime($data_search["time_start"]));
}
if (isset($data_search["time_end"]) && !empty(trim($data_search["time_end"]))) {
$conditions['DATE_ADD(MemberBookFacility.time, INTERVAL 1 hour) <= '] = $data_search["time_end"]; // date('H:i', strtotime($data_search["time_end"]));
}