Symfony2 Create Query Builder Only Month or Day or Year Search Mysql

we will use SUBSTRING function

$monht = 12; or 11 or 01 your choice
$variable = $em->createQueryBuilder()
                ->select('sd')
                ->from('YourEntitypath','sd')
                ->where('SUBSTRING(sd.fulltime,6,2) =:month') 6,2 important
                ->andWhere('sd.otherwhere  =:other')
                ->setParameter('month',$monht)
                ->setParameter('other',$var)
                ->orderBy('sd.fulltime','ASC')
                ->getQuery()
                ->getResult();