Doctrine querybuilder DATE_FORMAT不工作 [英] Doctrine querybuilder DATE_FORMAT not working
问题描述
我在一个createQueryBuilder中遇到了DATE_FORMAT的问题
我的代码:
$ cb7Days = $ repo-> createQueryBuilder('R')
- > select('R.createdAt')
- > where(DATE_FORMAT(R.createdAt ,'%Y-%m-%d')=:afterDays)
- > andWhere('R.cCurrentReviewState =:state')
- > andWhere('R.reminder =提醒)
- > setParameter('afterDays',$ after7Days)
- > setParameter('state',$ oReviewStateNotVerified)// not_verified
- > setParameter('reminder' ,0)//从未发送任何提醒
- > orderBy('R.id','ASC')
- > getQuery();
但是获取
[Doctrine\ORM\Query\QueryException]
[语法错误]行0,列7:错误:预期的已知功能,获得'DATE_FORMAT'
我已经搜索了一些链接,并找到一些解释,它应该这样工作,但对我来说,看起来我做错了事情。 / p>
http://www.uvd.co.uk/blog/labs/using-mysqls-date_format-in-doctrine-2-0/
DATE_FORMAT
以及一堆Mysql函数在Doctrine中不能直接使用。
要使用它们,您可以创建自己的或添加一个扩展名,如 beberlei / DoctrineExtensions
然后将相应的功能添加到您的教条束配置中,如
doctrine:
dbal:
....
orm:
....
dql:
string_functions:
DATE_FORMAT:DoctrineExtensions\Query\Mysql\DateFormat
I'm having some problems with DATE_FORMAT inside a createQueryBuilder
My code:
$qb7Days = $repo->createQueryBuilder('R')
->select( 'R.createdAt' )
->where( "DATE_FORMAT(R.createdAt, '%Y-%m-%d') = :afterDays" )
->andWhere( 'R.cCurrentReviewState = :state' )
->andWhere( 'R.reminder = :reminder' )
->setParameter( 'afterDays', $after7Days )
->setParameter( 'state', $oReviewStateNotVerified ) // not_verified
->setParameter( 'reminder', 0 ) // never sent any reminder
->orderBy( 'R.id', 'ASC' )
->getQuery();
But im getting
[Doctrine\ORM\Query\QueryException]
[Syntax Error] line 0, col 7: Error: Expected known function, got 'DATE_FORMAT'
I've searched some links and find some explain that it should work this way, but for me it looks like im doing something wrong.
http://www.uvd.co.uk/blog/labs/using-mysqls-date_format-in-doctrine-2-0/
DATE_FORMAT
along with a bunch of Mysql function are not directly available in Doctrine.
To use them you can either create your own or add an extension like beberlei/DoctrineExtensions
and then add the respective function to your doctrine bundle config like
doctrine:
dbal:
....
orm:
....
dql:
string_functions:
DATE_FORMAT: DoctrineExtensions\Query\Mysql\DateFormat
这篇关于Doctrine querybuilder DATE_FORMAT不工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!