Compare two date fields in doctrine (ignoring the time part)

Asked Jul 15 '14 at 10:24

Active Nov 08 '22 at 15:26

Viewed 775 times

I am trying to compare if two fields have same date. They may have different time part, but if the date is the same I count them 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 fields. I want to compare and check if they have the same date (not necessarily the same time) but can't make it.

edited Nov 08 '22 at 15:26

Alphonse

asked Jul 15 '14 at 10:24

Sokmesa Khiev

2,910
3
19
30

Where's your `->from('YourBundle:YourEntity', 'c')` after select ? – Anjana Silva Jul 15 '14 at 10:31
`->where("DATEDIFF(a.awardIssuedDate, c.awardDeadlineInit) = 0")` – Aleksei Matiushkin Jul 15 '14 at 10:34
@mudasobwa's suggestion is seems legit. But I believe you will find kind a same question in here :- http://stackoverflow.com/questions/10681158/how-to-compare-datetime-field-from-doctrine2-with-a-date – Anjana Silva Jul 15 '14 at 10:36
@AnjanaSilva I don't need to call from method as this code is in my entity repository. – Sokmesa Khiev Jul 15 '14 at 10:38
@mudasobwa it got error with undefined DATEDIFF – Sokmesa Khiev Jul 15 '14 at 10:42
if that is codeigniter...try this...left join command: $this->db->join('comments', 'comments.id = blogs.id', 'left'); see the word "left" on the 3rd arguments. – rm_beginners Jul 15 '14 at 10:42
It is Symfony2 framework – Sokmesa Khiev Jul 15 '14 at 10:43
try to put your $q in die($q) after ->getQuery(); to see the output of your query then try to manually try it in your database application. that the way i troubleshoot my program. I just want to share. – rm_beginners Jul 15 '14 at 10:47
SELECT c.year,c.number FROM ACF\CaseBundle\Entity\ConflictOutcome a LEFT JOIN a.conflict c WHERE DATEDIFF(a.awardIssuedDate, c.awardDeadlineInit) = 0 – Sokmesa Khiev Jul 15 '14 at 14:56
I got the solution. We should not use DATEDIFF but DATE_DIFF – Sokmesa Khiev Jul 15 '14 at 15:02

Compare two date fields in doctrine (ignoring the time part)

0 Answers0