Question : Add 2 hours to current time in cakephp
Answered by : vi-ly
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"]));
}Source : | Last Update : Wed, 04 Nov 20