Devart ODBC Driver for xBase supports the following numerical SQL functions.
| Function | Description |
|---|---|
ABS(X) |
Returns the absolute value of numeric expression X. |
CEIL(X) |
Returns the smallest integer that is greater than or equal to numeric expression X. |
FLOOR(X) |
Returns the largest integer that is less than or equal to numeric expression X. |
INT(X) |
Returns the integer portion of numeric expression X by removing the decimal part. |
LOG(X) |
Returns the natural logarithm (base e) of numeric expression X. |
LOG10(X) |
Returns the base-10 logarithm of numeric expression X. |
MAX(A, B) |
Returns the greater value of numeric expressions A and B. |
MIN(A, B) |
Returns the lesser value of numeric expressions A and B. |
MOD(A, B) |
Returns the remainder of numeric expression A divided by numeric expression B. |
ROUND(X[, N]) |
Rounds numeric expression X to N decimal places. If N is 0, the function returns the same result as INT(X). |
SQRT(X) |
Returns the square root of numeric expression X. |
Note
Devart ODBC Driver for xBase is powered by the SQLite engine, therefore the driver also supports the full set of mathematical SQL functions supported by Devart ODBC Driver for SQLite.