doctrine querybuilder get nearest datetime

Question

I've been looking for hours to get the right syntax for the doctrine query builder. I need to get the oldest value in the DB.

colums:

id, dateCreated, value

query: (that doesn't works)

->select('c')
->where(
    $qb->expr()->eq('c.dateCreated', $qb->expr()->min('c.dateCreated')) 
)

can someone tells me how to build the right query for my need please. Thanks guys!

Just sort the result set by dateCreated with addition of limiting to 1 result and you should be good to go. — Artamiel
– Artamiel, Commented Mar 23, 2016 at 20:42

smarber · Accepted Answer · 2016-03-23 21:43:09Z

2

You should just sort returned values and only get the first one (depending on the ordering)

$select('c')->orderBy('c.expDate', 'ASC')->setMaxResults(1);

answered Mar 23, 2016 at 21:43

smarber

5,1447 gold badges41 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1