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

by

In addition to the accepted answer there are a tonne of pre-built custom functions available at https://github.com/beberlei/DoctrineExtensions .

These can be then registered in your config like

doctrine:
    orm:
        dql:
            string_functions:
                DATE: DoctrineExtensions\Query\Mysql\Date

and can then be used in your DQL (as in your query) like

DATE(jobs.endDate) AS endDate

More Related Contents:

  1. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  2. Doctrine Query Language get Max/Latest Row Per Group
  3. How to set up entity (doctrine) for database view in Symfony 2
  4. How to force Doctrine to update array type fields?
  5. Query on a many-to-many relationship using Doctrine with Symfony2
  6. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  7. On delete cascade with doctrine2
  8. Why doesn’t MySQL support millisecond / microsecond precision?
  9. Doctrine 2 and Many-to-many link table with an extra field
  10. Symfony: Clear doctrine cache
  11. How to re-save the entity as another row in Doctrine 2
  12. Generating a single Entity from existing database using symfony2 and doctrine
  13. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  14. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  15. Symfony error The class XXX was not found in the chain configured namespaces XXX
  16. Doctrine – How to print out the real sql, not just the prepared statement?
  17. How to setup table prefix in symfony2
  18. PDOException “could not find driver” in php
  19. Symfony 2.0 getting service inside entity
  20. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  21. Can I access discriminator field from php in doctrine2?
  22. Join subquery with doctrine 2 DBAL
  23. storing user_id in session variable
  24. How do I set ORDER BY params using prepared PDO statement?
  25. PHP/MySQL Insert null values
  26. Can you add an if statement in ORDER BY?
  27. MySQL (or PHP?) group results by field data
  28. How to access an application parameters from a service?
  29. Check if a row exists using old mysql_* API
  30. What is the best way to notify a user after an access_control rule redirects?

Leave a Comment