Query Example (Doctrine2 QueryBuilder)

gistfile1.aw

        $qb = $em->createQueryBuilder();
        $qb->select('p')
            ->from('AcmeTestBundle:Post', 'p')
            ->where('p.order_date < :targetDate')
            ->setParameters(array(
                'targetDate' => new \DateTime('2011-08-07'),
            ));
        $q = $qb->getQuery();