How can I use now() in Doctrine 2 DQL?

mysql symfony doctrine-orm dql
Eduardo picture Eduardo · Dec 1, 2011 · Viewed 29.9k times · Source 
$ php app/console doctrine:query:dql 'SELECT NOW()'

[Doctrine\ORM\Query\QueryException] [Syntax Error] line 0, col 7: Error: Expected known function, got 'now'

How can I use MySQL's NOW() function with Doctrine's DQL?

Answer

Benjamin picture Benjamin · Dec 3, 2011

The equivalent of MySQL's NOW() is Doctrine DQL's CURRENT_TIMESTAMP().

CURRENT_DATE() only returns the date part.

Reference: DQL date/time related functions

Related questions

Doctrine 2 DQL CASE WHEN in Count

I have this Query in native MySQL Code SELECT * FROM `turn` LEFT JOIN ( poi ) ON ( turn.id = poi.turn_id ) GROUP BY turn.id ORDER BY count( case when poi.image = 1 then 1 else null end) DESC; I need to rebuild …

Read More
Troubleshooting "No such file or directory" when running `php app/console doctrine:schema:create`

I am new to Symfony2 (beta4) and Doctrine and am having issues when i try to create the DB schema via command line. Here's the error: $ php app/console doctrine:schema:create Creating database schema... [PDOException] SQLSTATE[HY000] [2002] No such …

Read More
Doctrine2 migrations migrate down and migrate from browser and not command line

I am using Doctrine2 migrations. I need some answers about my doubt, I canno find a good solution in documentations I use: doctrine migrations:diff // generate migrations files doctrine migrations:migrate // migrates up to new version How Can I migrate …

Read More