Math Canonical Functions
Entity SQL includes the following math canonical functions:
Abs(value)
Returns the absolute value of value.
Arguments
An Int16, Int32, Int64, Byte, Single, Double, and Decimal.
Return Value
The type of value.
Example
Abs(-2)
Ceiling(value)
Returns the smallest integer that is not less than value.
Arguments
A Single, Double, and Decimal.
Return Value
The type of value.
Example
SELECT VALUE product FROM AdventureWorksEntities.Products AS product
WHERE CEILING(product.ListPrice) == FLOOR(product.ListPrice)
SELECT VALUE product FROM AdventureWorksEntities.Products AS product
WHERE CEILING(product.ListPrice) == FLOOR(product.ListPrice)
Floor(value)
Returns the largest integer that is not greater than value.
Arguments
A Single, Double, and Decimal.
Return Value
The type of value.
Example
SELECT VALUE product FROM AdventureWorksEntities.Products AS product
WHERE FLOOR(product.ListPrice) == CEILING(product.ListPrice)
SELECT VALUE product FROM AdventureWorksEntities.Products AS product
WHERE FLOOR(product.ListPrice) == CEILING(product.ListPrice)
Power(value, exponent)
Returns the result of the specified value to the specified exponent.
Arguments
| Parameter | Type |
|---|---|
value |
Int32, Int64, Double, or Decimal. |
exponent |
Int64, Double, or Decimal. |
Return Value
The type of value.
Example
Power(748.58,2)
Round(value)
Returns the integer portion of value, rounded to the nearest integer.
Arguments
A Single, Double, and Decimal.
Return Value
The type of value.
Example
Round(748.58)
Round(value, digits)
Returns the value, rounded to the nearest specified digits.
Arguments
| Parameter | Type |
|---|---|
value |
Double or Decimal. |
digits |
Int16 or Int32. |
Return Value
The type of value.
Example
Round(748.58,1)
Truncate(value, digits)
Returns the value, truncated to the nearest specified digits.
Arguments
| Parameter | Type |
|---|---|
value |
Double or Decimal. |
digits |
Int16 or Int32. |
Return Value
The type of value.
Example
Truncate(748.58,1)
These functions will return null if given null input.
Equivalent functionality is available in the Microsoft SQL Client Managed Provider. For more information, see SqlClient for Entity Framework Functions.