Extract extends FunctionNode
EXTRACT (field FROM [type] source) field: 単位指定子 - YEAR - MONTH - DAY - HOUR - MINUTE - SECOND - WEEK type: 日付/時刻データ型 sourceが文字列の場合のみ必須 - TIMESTAMP - DATE - TIME source: 日付/時刻データ型、もしくは日付/時刻を表す文字列 文字列の場合はtypeが必須
Table of Contents
| $field | ||
|---|---|---|
| $type | ||
| $source | ||
| $formats | ||
| $dateTimeTypes | ||
| parse() | mixed | |
| getSql() | mixed |
Properties
$field
protected
mixed
$field
$type
protected
mixed
$type
$source
protected
mixed
$source
$formats
protected
mixed
$formats
= ['YEAR' => '%Y', 'MONTH' => '%m', 'DAY' => '%d', 'HOUR' => '%H', 'MINUTE' => '%M', 'SECOND' => '%S', 'WEEK' => '%W']
$dateTimeTypes
protected
mixed
$dateTimeTypes
= ['TIMESTAMP', 'DATE', 'TIME']
Methods
parse()
public
parse(
$parser :
Parser
)
: mixed
Parameters
- $parser : Parser
Return values
mixedgetSql()
public
getSql(
$sqlWalker :
SqlWalker
)
: mixed
Parameters
- $sqlWalker : SqlWalker