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

4

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

answered Sep 2, 2017 at 19:55

Matteo

39.8k11 gold badges110 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to create a symfony query > date

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related