Select entries between dates in doctrine 2

by

You can do either…

$qb->where('e.fecha BETWEEN :monday AND :sunday')
   ->setParameter('monday', $monday->format('Y-m-d'))
   ->setParameter('sunday', $sunday->format('Y-m-d'));

or…

$qb->where('e.fecha > :monday')
   ->andWhere('e.fecha < :sunday')
   ->setParameter('monday', $monday->format('Y-m-d'))
   ->setParameter('sunday', $sunday->format('Y-m-d'));

More Related Contents:

  1. How to use WHERE IN with Doctrine 2
  2. Subquery in doctrine2 notIN Function
  3. Join subquery with doctrine 2 DBAL
  4. Week of the day for current date in php [closed]
  5. Convert a date format in PHP [duplicate]
  6. Adding days to $Date in PHP
  7. How to check if a date is in a given range?
  8. PHP check if date between two dates
  9. PHP compare time
  10. Add ‘x’ number of hours to date
  11. How can I find the first and last date in a month using PHP?
  12. Simplest way to increment a date in PHP?
  13. How to count days between two dates in PHP?
  14. How to get previous month and year relative to today, using strtotime and date?
  15. PHP order array by date? [duplicate]
  16. How to get closest date compared to an array of dates in PHP
  17. how to find number of mondays or tuesdays between two dates?
  18. How to convert ISO8601 to Date format in php
  19. How to calculate time difference in PHP? [duplicate]
  20. How do I find the hour difference between two dates in PHP?
  21. PHP date – get name of the months in local language
  22. Symfony 2.0 getting service inside entity
  23. How do you explain the result for a new \DateTime(‘0000-00-00 00:00:00’)?
  24. Increase days to php current Date()
  25. Convert to date format dd/mm/yyyy
  26. PHP: add seconds to a date
  27. Can I access discriminator field from php in doctrine2?
  28. day of the week to day number (Monday = 1, Tuesday = 2)
  29. php weeks between 2 dates
  30. PHP: Date larger than current date

Leave a Comment