dongwei3172
2018-08-16 11:03
浏览 92
已采纳

Doctrine 2.2 Symfony 3.4中的日期时间字符串转换

I am troubleshooting a search bar to return rows within a period chosen from 'To' and 'From' datepickers.

I initially got this error :

Error: Method Doctrine\ORM\Query\Expr\Comparison::__toString() must not throw an exception, caught Symfony\Component\Debug\Exception\ContextErrorException: Catchable Fatal Error: Object of class DateTime could not be converted to string

I converted the relevant query to a string using ->format() function:

            if (is_array($value) && isset($value['to'])) {

            $to = \DateTime::createFromFormat('d/m/Y H:i:s', $value['from'] . ' 23:59:59');
            var_dump($value, $to);die;
            if ($to <> false) {
                $query->andWhere(
                        $query->expr()->lte($path, $to->format('Y-m-d H:i:s'))
                );
            }
        }

Now doctrine throws the following error:

[Syntax Error] line 0, col 977: Error: Expected end of string, got '00'

Is there something else I need to do to format the date to make it acceptable to the querybuilder? I've tried using / instead of : but this causes an issue.

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

相关推荐 更多相似问题