*/ class Extract extends DateAdd { public $date = null; public $unit = null; public function parse(\Doctrine\ORM\Query\Parser $parser) { $parser->match(Lexer::T_IDENTIFIER); $parser->match(Lexer::T_OPEN_PARENTHESIS); $parser->match(Lexer::T_IDENTIFIER); $lexer = $parser->getLexer(); $this->unit = $lexer->token['value']; $parser->match(Lexer::T_IDENTIFIER); $this->date = $parser->ArithmeticPrimary(); $parser->match(Lexer::T_CLOSE_PARENTHESIS); } public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker) { $unit = strtoupper($this->unit); if (!in_array($unit, self::$allowedUnits)) { throw QueryException::semanticalError('EXTRACT() does not support unit "' . $unit . '".'); } return 'EXTRACT(' . $unit . ' FROM '. $this->date->dispatch($sqlWalker) . ')'; } }