DDC-697: Support for DateTime in query parameters #859

New Issue

admin · 2026-01-22T12:52:54+01:00

admin commented

2026-01-22 12:52:54 +01:00

Originally created by @doctrinebot on GitHub (Jul 19, 2010).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user vrtak-cz:

Supports native DateTime in query parameters. (for more universal using)

/****
 * @var DateTime
 *
 * @Column(type="datetime")
 */
private $published;

$qb = $em->getRepository('Entities\Foo')->createQueryBuilder('f');
$qb->where("f.published <= ?1");
$qb->setParameter(1, new \DateTime('2012-12-21 23:59:59'));

Now display "Object of class DateTime could not be converted to string" error

Originally created by @doctrinebot on GitHub (Jul 19, 2010). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user vrtak-cz: Supports native DateTime in query parameters. (for more universal using) ``` /**** * @var DateTime * * @Column(type="datetime") */ private $published; ``` ``` $qb = $em->getRepository('Entities\Foo')->createQueryBuilder('f'); $qb->where("f.published <= ?1"); $qb->setParameter(1, new \DateTime('2012-12-21 23:59:59')); ``` Now display "Object of class DateTime could not be converted to string" error

admin added the New Feature label 2026-01-22 12:52:54 +01:00

admin closed this issue

2026-01-22 12:52:55 +01:00

admin commented

2026-01-22 12:52:56 +01:00

@doctrinebot commented on GitHub (Jul 19, 2010):

Comment created by @beberlei:

This is another case for possible optimizations in my opinion, is it possible to access the parameter needles from the ResultSetMapping? If so then we should add a convertToParam method to each Doctrine\DBAL\Types\Type and allow conversions to take place or just do nothing. This woulld help with this issue, aswell as with other more complex types to be bound.

@doctrinebot commented on GitHub (Jul 19, 2010): Comment created by @beberlei: This is another case for possible optimizations in my opinion, is it possible to access the parameter needles from the ResultSetMapping? If so then we should add a convertToParam method to each Doctrine\DBAL\Types\Type and allow conversions to take place or just do nothing. This woulld help with this issue, aswell as with other more complex types to be bound.

admin commented

2026-01-22 12:52:58 +01:00

@doctrinebot commented on GitHub (Jul 19, 2010):

Comment created by @beberlei:

This affects the following loop inside Doctrine\ORM\Query:

http://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Query.php#L234

@doctrinebot commented on GitHub (Jul 19, 2010): Comment created by @beberlei: This affects the following loop inside Doctrine\ORM\Query: http://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Query.php#L234

admin commented

2026-01-22 12:52:58 +01:00

@doctrinebot commented on GitHub (Jul 20, 2010):

Comment created by @beberlei:

According to Roman this should already be possible with:

$qb->setParameter(1, new \DateTime('2012-12-21 23:59:59'), \Doctrine\DBAL\Types\Type::DATETIME);

can you verify this?

@doctrinebot commented on GitHub (Jul 20, 2010): Comment created by @beberlei: According to Roman this should already be possible with: ``` $qb->setParameter(1, new \DateTime('2012-12-21 23:59:59'), \Doctrine\DBAL\Types\Type::DATETIME); ``` can you verify this?

admin commented

2026-01-22 12:53:00 +01:00

@doctrinebot commented on GitHub (Jul 20, 2010):

Comment created by vrtak-cz:

$qb->setParameter(1, new \DateTime('2012-12-21 23:59:59'), \Doctrine\DBAL\Types\Type::DATETIME);

No this featrue not work for me. (Same error message) I'm tested at latest BETA release & latest code from master branch (GitHub).

@doctrinebot commented on GitHub (Jul 20, 2010): Comment created by vrtak-cz: ``` $qb->setParameter(1, new \DateTime('2012-12-21 23:59:59'), \Doctrine\DBAL\Types\Type::DATETIME); ``` No this featrue not work for me. (Same error message) I'm tested at latest BETA release & latest code from master branch (GitHub).

admin commented

2026-01-22 12:53:01 +01:00

@doctrinebot commented on GitHub (Jul 21, 2010):

Comment created by @beberlei:

Fixed, QueryBuilder::setParameter() and QueryBuilder::setParameters() did not yet support setting parameter types.

@doctrinebot commented on GitHub (Jul 21, 2010): Comment created by @beberlei: Fixed, QueryBuilder::setParameter() and QueryBuilder::setParameters() did not yet support setting parameter types.

admin commented

2026-01-22 12:53:02 +01:00

@doctrinebot commented on GitHub (Jul 21, 2010):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Jul 21, 2010): Issue was closed with resolution "Fixed"

admin referenced this issue

2026-01-22 16:01:49 +01:00

[PR #859] [CLOSED] [DDC-2816] Adds a preQueryExecute event #8811

admin referenced this issue

2026-01-22 16:01:50 +01:00

[PR #859] [DDC-2816] Adds a preQueryExecute event #8816

Sign in to join this conversation.