Dá uma olhada aqui oh: http://www.doctrine-project.org/blog/doctrine2-custom-dql-udfs.html
2014-02-03 marceloleob <[email protected]>: > > Issac_musashi, obrigado mas não resolveu meu problema.. > > Com sua "idéia" tentei alterar para: > > $em = $this->getEntityManager(); > > $query = $em->createQuery(' > SELECT > SUM(PERIOD_DIFF(DATE_FORMAT(q.dtFim, \'%Y%m\'), > DATE_FORMAT(q.dtInicio, \'%Y%m\'))) AS totalMes > FROM > app:Bolsista q > WHERE > q.pessoa_id = :pessoa AND > q.tipobolsista_id = :tipoBolsaEstagio > ativo = :ativo') > ->setParameter('pessoa', $pessoaId) > ->setParameter('tipoBolsaEstagio', $tipoBolsa) > ->setParameter('ativo', 1); > > return $query->execute()->fetchAll(); > > mas mesmo assim não funfou! > > =/ > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/groups/opt_out. > -- ________________________________ Isaac Henrique Barbosa Nunes Analista e Desenvolvedor de Sistema -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/groups/opt_out.
