How can I use SQL’s YEAR(), MONTH() and DAY() in Doctrine2?

by

You can add Doctrine extension so you can use the MySql YEAR and MONTH statement by adding this configuration if you’re on Symfony:

doctrine:
    orm:
        dql:
            string_functions:
                MONTH: DoctrineExtensions\Query\Mysql\Month
                YEAR: DoctrineExtensions\Query\Mysql\Year

now you can use the MONTH and YEAR statements in your DQL or querybuilder.

Note: The extension supports MySQL, Oracle, PostgreSQL and SQLite.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. SQL select only rows with max value on a column [duplicate]
  3. How to create a MySQL hierarchical recursive query?
  4. Error related to only_full_group_by when executing a query in MySql
  5. How to reset AUTO_INCREMENT in MySQL
  6. How to declare a variable in MySQL?
  7. MySQL Query GROUP BY day / month / year
  8. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  9. Grouping into interval of 5 minutes within a time range
  10. SQL counting all rows instead of counting individual rows
  11. Combining UNION and LIMIT operations in MySQL query
  12. MySQL comparison with null value
  13. MySQL Like multiple values
  14. In MySQL, should I quote numbers or not?
  15. Matching all values in IN clause
  16. MySQL add days to a date
  17. INTERSECT in MySQL
  18. Check for x consecutive days – given timestamps in database
  19. How do I get the ID of multiple inserted rows in MySQL?
  20. How to alter a column and change the default value?
  21. sql join tables where 1 column has comma
  22. Remove special characters from a database field
  23. MySQL – Replace Character in Columns
  24. update a column by subtracting a value
  25. How to SELECT by MAX(date)?
  26. The best way to remove value from SET field?
  27. INSERT INTO Table from multiple tables
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment