Expression mysql NOW() in Doctrine QueryBuilder

mysql doctrine doctrine-orm doctrine-query
user1906245 picture user1906245 · Dec 16, 2012 · Viewed 25.6k times · Source

How to use the expression mysql NOW() in doctrine querybuilder?

Answer

Mats Rietdijk picture Mats Rietdijk · Dec 17, 2012

In Doctrine2 you have to use one of the following instead of NOW().
This:

CURRENT_TIMESTAMP()

Or:

...
createQuery(...'WHERE x.date = :now')
->setParameter('now', new \DateTime('now'))
...

If you want only time or only date use one of those: CURRENT_TIME() and CURRENT_DATE()

Documentation can be found here.

Related questions

Doctrine Query to find total number of Result in MySQL with LIMIT

I am trying to fetch the total number of rows found for specific query when LIMIT is applied. I successfully found the answer in PHP/MySQL, But I am not able to conver the logic in Zend/Doctrine. I am …

Read More
Converting MySQL to Doctrine Query Builder. Issues with IF and CONCAT. Or another approach for subqueries on select

I have a table for my categories, each category have and id, name and parent_id. Select IF(a.parent_id IS NULL, a.name, CONCAT((SELECT b.name FROM category b WHERE b.id = a.parent_id), " / ", a.name) ) …

Read More
Doctrine - How to print out the real sql, not just the prepared statement?

We're using Doctrine, a PHP ORM. I am creating a query like this: $q = Doctrine_Query::create()->select('id')->from('MyTable'); and then in the function I'm adding in various where clauses and things as appropriate, …

Read More