doctrine2 - how to use DATE_ADD function

symfony doctrine-orm dql
brpaz picture brpaz · Dec 10, 2012 · Viewed 16.1k times · Source

I am trying to use the DATE_ADD function from doctrine2 but I am having trouble get it right.

I am using like this in DQL:

->andWhere('p.created_at <= DATE_ADD(CURRENT_DATE(),4, day)')

but I am getting syntax error:

[Syntax Error] line 0, col 215: Error: Expected'.' or '(', got 'day'

I tried different implementations but I allways get some kind of syntax errror.

I have checked DoctrineExtensions which contain this function, but I shouldnt need it because the function is already included in doctrine.

Answer

Pierrickouw picture Pierrickouw · Dec 10, 2012

You have a typo, you have to quotes 'day' 

->andWhere("p.created_at <= DATE_ADD(CURRENT_DATE(),4, 'day')")

An example here.

Related questions

Symfony2 and Doctrine - Error: Invalid PathExpression. Must be a StateFieldPathExpression

I have an entity that looks like this: /** * @Gedmo\Tree(type="nested") * @ORM\Table(name="categories") * @ORM\Entity() */ class Category extends BaseCategory { /** * @ORM\OneToMany(targetEntity="Category", mappedBy="parent") */ protected $children; /** * @Gedmo\TreeParent * @ORM\ManyToOne(targetEntity="Category", inversedBy="children") * @ORM\JoinColumn(…

Read More
Symfony getting logged in user's id

I am developing an application using Symfony2 and doctrine 2. I would like to know how can I get the currently logged in user's Id.

Read More
How to do a LIKE database query in Symfony2

This should be simple but I can't find a working example. Here's a controller method that throws the error "Invalid parameter number: number of bound variables does not match number of tokens". I'm posting the "searchterm" variable successfully but can't …

Read More