I am stuck when trying to compare if two field is in the same day. It have different hours but in the same day so I count it as equal.
$q = $this->createQueryBuilder("a")
->select('c.year,c.number')
->leftJoin('a.conflict', 'c')
->where("a.awardIssuedDate = c.awardDeadlineInit")
->getQuery();
$cases = $q->getResult();
return $cases;
The fields awardIssuedDate and awardDeadlineInit are datetime field. I want to compare if it have the same date and not require the same time but still can't make it.
Thanks for your help :)