how to create a symfony query > date

Question

i'm trying to do a query that find entity of this year .

i try this but don't work

$em = $this->getDoctrine()->getManager(); $query = $em->createQuery( 'SELECT p FROM AppBundle:Analisi p WHERE p.dataCreazione > :current_year ORDER BY p.dataCreazione ASC' )->setParameter('current_year', date("Y").'01-01'); $analisi = $query->getResult();

it return analisi in database. It don't work but i don't understand why

Can you show your error?

Imanali Mamadiev
– Imanali Mamadiev

2017-09-02 17:53:24 +00:00
Commented Sep 2, 2017 at 17:53 — Imanali Mamadiev
– Imanali Mamadiev, Commented Sep 2, 2017 at 17:53

Matteo · Accepted Answer · 2017-09-02 19:55:29Z

try with one more minus symbol as: date("Y").'-01-01')

 ->setParameter('current_year', date("Y").'-01-01');

more readable way could be:

 $date= date('Y-m-d', strtotime('first day of january this year')); $query = $em->createQuery( 'SELECT p FROM AppBundle:Analisi p WHERE p.dataCreazione > :current_year ORDER BY p.dataCreazione ASC' )->setParameter('current_year', $date);

Hope this help

Collectives™ on Stack Overflow

how to create a symfony query > date

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related