Contains methods related to generating FunctionExpression objects with most commonly used SQL functions.
This acts as a factory for FunctionExpression objects.
Returns a FunctionExpression representing the difference in days between two dates.
Returns a FunctionExpression representing a call that will return the current date and time. By default it returns both date and time, but you can also make it generate only the date or only the time.
__call(string $name, array $args)
Magic method dispatcher to create custom SQL function calls
string
$name the SQL function name to construct
array
$args list with up to 3 arguments, first one being an array with parameters for the SQL function, the second one a list of types to bind to those params, and the third one the return type of the function
\Cake\Database\Expression\FunctionExpression
aggregate(string $name, array $params, array $types, string $return)
Helper method to create arbitrary SQL aggregate function calls.
string
$name The SQL aggregate function name
array
$params optional Array of arguments to be passed to the function. Can be an associative array with the literal value or identifier: ['value' => 'literal']
or `['value' => 'identifier']
array
$types optional Array of types that match the names used in $params
: ['name' => 'type']
string
$return optional Return type of the entire expression. Defaults to float.
\Cake\Database\Expression\AggregateExpression
avg(mixed $expression, mixed $types)
Returns a AggregateExpression representing a call to SQL AVG function.
string|\Cake\Database\ExpressionInterface
$expression the function argument
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\AggregateExpression
cast(mixed $field, string $type)
Returns a FunctionExpression representing a SQL CAST.
The $type
parameter is a SQL type. The return type for the returned expression is the default type name. Use setReturnType()
to update it.
string|\Cake\Database\ExpressionInterface
$field Field or expression to cast.
string
$type optional The SQL data type
\Cake\Database\Expression\FunctionExpression
coalesce(array $args, array $types)
Returns a FunctionExpression representing a call to SQL COALESCE function.
array
$args List of expressions to evaluate as function parameters
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\FunctionExpression
concat(array $args, array $types)
Returns a FunctionExpression representing a string concatenation
array
$args List of strings or expressions to concatenate
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\FunctionExpression
count(mixed $expression, mixed $types)
Returns a AggregateExpression representing a call to SQL COUNT function.
string|\Cake\Database\ExpressionInterface
$expression the function argument
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\AggregateExpression
dateAdd(mixed $expression, mixed $value, string $unit, array $types)
Add the time unit to the date expression
string|\Cake\Database\ExpressionInterface
$expression Expression to obtain the date part from.
string|int
$value Value to be added. Use negative to subtract.
string
$unit Unit of the value e.g. hour or day.
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\FunctionExpression
dateDiff(array $args, array $types)
Returns a FunctionExpression representing the difference in days between two dates.
array
$args List of expressions to obtain the difference in days.
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\FunctionExpression
datePart(string $part, mixed $expression, array $types)
Returns the specified date part from the SQL expression.
string
$part Part of the date to return.
string|\Cake\Database\ExpressionInterface
$expression Expression to obtain the date part from.
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\FunctionExpression
dayOfWeek(mixed $expression, mixed $types)
Returns a FunctionExpression representing a call to SQL WEEKDAY function.
1 - Sunday, 2 - Monday, 3 - Tuesday...
string|\Cake\Database\ExpressionInterface
$expression the function argument
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\FunctionExpression
extract(string $part, mixed $expression, array $types)
Returns the specified date part from the SQL expression.
string
$part Part of the date to return.
string|\Cake\Database\ExpressionInterface
$expression Expression to obtain the date part from.
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\FunctionExpression
lag(mixed $expression, int $offset, mixed $default, mixed $type)
Returns an AggregateExpression representing call to SQL LAG().
\Cake\Database\ExpressionInterface|string
$expression The value evaluated at offset
int
$offset The row offset
mixed
$default optional The default value if offset doesn't exist
string
$type optional The output type of the lag expression. Defaults to float.
\Cake\Database\Expression\AggregateExpression
lead(mixed $expression, int $offset, mixed $default, mixed $type)
Returns an AggregateExpression representing call to SQL LEAD().
\Cake\Database\ExpressionInterface|string
$expression The value evaluated at offset
int
$offset The row offset
mixed
$default optional The default value if offset doesn't exist
string
$type optional The output type of the lead expression. Defaults to float.
\Cake\Database\Expression\AggregateExpression
max(mixed $expression, mixed $types)
Returns a AggregateExpression representing a call to SQL MAX function.
string|\Cake\Database\ExpressionInterface
$expression the function argument
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\AggregateExpression
min(mixed $expression, mixed $types)
Returns a AggregateExpression representing a call to SQL MIN function.
string|\Cake\Database\ExpressionInterface
$expression the function argument
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\AggregateExpression
now(string $type)
Returns a FunctionExpression representing a call that will return the current date and time. By default it returns both date and time, but you can also make it generate only the date or only the time.
string
$type optional (datetime|date|time)
\Cake\Database\Expression\FunctionExpression
rand()
Returns a FunctionExpression representing a call to SQL RAND function.
\Cake\Database\Expression\FunctionExpression
rowNumber()
Returns an AggregateExpression representing call to SQL ROW_NUMBER().
\Cake\Database\Expression\AggregateExpression
sum(mixed $expression, mixed $types)
Returns a AggregateExpression representing a call to SQL SUM function.
string|\Cake\Database\ExpressionInterface
$expression the function argument
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\AggregateExpression
toLiteralParam(mixed $expression)
Creates function parameter array from expression or string literal.
\Cake\Database\ExpressionInterface|string
$expression function argument
(\Cake\Database\ExpressionInterface|string)[]
weekday(mixed $expression, mixed $types)
Returns a FunctionExpression representing a call to SQL WEEKDAY function.
1 - Sunday, 2 - Monday, 3 - Tuesday...
string|\Cake\Database\ExpressionInterface
$expression the function argument
array
$types optional list of types to bind to the arguments
\Cake\Database\Expression\FunctionExpression
© 2005–present The Cake Software Foundation, Inc.
Licensed under the MIT License.
CakePHP is a registered trademark of Cake Software Foundation, Inc.
We are not endorsed by or affiliated with CakePHP.
https://api.cakephp.org/4.1/class-Cake.Database.FunctionsBuilder.html