Use a DATE() function in a WHERE clause with DQL

by

You can achieve what you want by using a custom function:

use Doctrine\ORM\Query\AST\Functions\FunctionNode;
use Doctrine\ORM\Query\Lexer;
use Doctrine\ORM\Query\SqlWalker;
use Doctrine\ORM\Query\Parser;

class DateFunction extends FunctionNode
{
    private $arg;

    public function getSql(SqlWalker $sqlWalker)
    {
        return sprintf('DATE(%s)', $this->arg->dispatch($sqlWalker));
    }

    public function parse(Parser $parser)
    {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);

        $this->arg = $parser->ArithmeticPrimary();

        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }
}

Then registering this function in your code:

$em->getConfiguration()->addCustomDatetimeFunction('DATE', 'DateFunction');

And your DQL query will work!

More Related Contents:

  1. Explicitly set Id with Doctrine when using “AUTO” strategy
  2. Limiting a doctrine query with a fetch-joined collection?
  3. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  4. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  5. How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?
  6. How to select randomly with doctrine
  7. How to re-save the entity as another row in Doctrine 2
  8. Symfony2 and Doctrine – Error: Invalid PathExpression. Must be a StateFieldPathExpression
  9. Can I access discriminator field from php in doctrine2?
  10. How to force Doctrine to update array type fields?
  11. CASTING attributes for Ordering on a Doctrine2 DQL Query
  12. How can I use DATE() in Doctrine 2 DQL?
  13. Count Rows in Doctrine QueryBuilder
  14. On delete cascade with doctrine2
  15. How to use WHERE IN with Doctrine 2
  16. PHPUnit Mock Objects and Static Methods
  17. Too much data with var_dump in symfony2 doctrine2
  18. symfony2: how to use group_concat in QueryBuilder
  19. Symfony error The class XXX was not found in the chain configured namespaces XXX
  20. The EntityManager is closed
  21. Doctrine – A new entity was found through the relationship
  22. Doctrine 2 mysql FIELD function in order by
  23. Symfony 2.0 getting service inside entity
  24. The differences between GeneratedValue strategies
  25. Doctrine query builder using inner join with conditions
  26. How can I use SQL’s YEAR(), MONTH() and DAY() in Doctrine2?
  27. How to convert this to Doctrine 2 QueryBuilder format?
  28. INNER JOIN Results from Select Statement using Doctrine QueryBuilder
  29. Memory leaks Symfony2 Doctrine2 / exceed memory limit
  30. Join subquery with doctrine 2 DBAL

Leave a Comment