php - WHERE clause on 'date' column -

i've got table column of type date. in script, generate date array follows :

$date2 = date('y-d-m', strtotime($date2)); ($i = 0; $i <= 7; $i++) {     $date1 = str_replace('-', '/', $date2);     $tomorrow = date('y-d-m',strtotime($date1 . "+".$i." days"));      echo 'counted date : '.$tomorrow.php_eol ;     array_push($dates, $tomorrow); } 

and got following output :

counted date : 2016-01-08 counted date : 2016-02-08 counted date : 2016-03-08 counted date : 2016-04-08 counted date : 2016-05-08 counted date : 2016-06-08 counted date : 2016-07-08 counted date : 2016-08-08 

i got phalcon expression :

$status1 = $app     ->modelsmanager     ->executequery("         select *            mastersfulltime           mastersfulltime.date = :date:            , mastersfulltime.master_id = :master_id:"         ,         array(             'date' => $date ,              'master_id' => $master_id         )     ); 

but where mastersfulltime.date = :date: not working. how can compare date objects? in advance!