Doctrine: calculating datetime difference

Question

How can i calculate the difference between datetime column and now (for example 'created_at' and NOW()) in Doctrine?

I Googled it alot and couldn't find an answer..

Thanks in advance!

Answer 1

Have you tried this?

$query->select('DATEDIFF(NOW(), datetime column)')