How to get date difference in Doctrine Query Language (dql)? How to get date difference in Doctrine Query Language (dql)? symfony symfony

How to get date difference in Doctrine Query Language (dql)?


You can use MySQL's TIMEDIFF (with TIME_TO_SEC and divide by 60) :

TIME_TO_SEC(TIMEDIFF(date1, date2)) / 60;

I believe you can implement it in Doctrine2 like in this example for DATE_DIFF.