Symfony2 日期时间查询生成器

2022-01-16 00:00:00 php symfony doctrine

我在 Symfony2 项目中有 2 个 DateTime 类.我有实体 Stat，其中有 $date 属性.

I have 2 DateTime classes in Symfony2 project. I have entity Stat, in which have $date property. 

/**
 * @ORMColumn(type="date", length="11")
 */
protected $date;

我必须使用 createQueryBuilder 中的 DateTime 对象进行查询.我怎样才能做到这一点 ?例如:

I have to make queries using DateTime objects in createQueryBuilder. How can i do that ? For example:

$date_from = new DateTime('2012-02-01');
$date_to = new DateTime('2012-02-15');

我需要从 $date_from 和 $date_to 之间的表 stats(实体 Stat)中获取所有行.我应该如何使用 createQueryBuilder 编写查询?我当前的代码是:

I need to get all rows from table stats (entity Stat) between $date_from and $date_to. How should i write my query with createQueryBuilder ? My current code is:

$qb = $em->createQueryBuilder();
$query = $qb->select('s')
            ->from('ACMEMyBundleEntityStat', 's')
            ->where('s.date >= :date_from')
            ->andWhere('s.date <= :date_to')
            ->setParameter('date_from', $date_from)
            ->setParameter('date_to', $date_to)
            ->getQuery();

推荐答案

本杰明的回答是正确的，但缺少一个细节.这是正确的做法:

Benjamin's answer is correct, but it lacks one detail. This is the correct way to do it:

$qb->andWhere($qb->expr()->between('s.date', ':date_from', ':date_to'));

但是要设置参数，我需要这样做:

But to set parameters, I need to do like this:

$qb->setParameter('date_from', $date_from, DoctrineDBALTypesType::DATETIME);
$qb->setParameter('date_to', $date_to, DoctrineDBALTypesType::DATETIME);

如果我省略 DATETIME 类型，我会收到以下错误(请参阅 这里):

If I omit the DATETIME types, I get the following error (see here):

DateTime 类的对象无法转换为字符串

Object of class DateTime could not be converted to string

我正在使用 Doctrine DBAL 2.0.5，这种行为可能在更高版本的 Doctrine 中有所改变.

I am using Doctrine DBAL 2.0.5, this behaviour might have changed in later versions of Doctrine.

相关文章