# Numeric Functions

The following table describes numeric functions that are included in the ODBC scalar function set. By calling **SQLGetInfo** with an *information type* of SQL_NUMERIC_FUNCTIONS, an application can determine which numeric functions are supported by a driver.

All numeric functions return values of data type SQL_FLOAT except for ABS, ROUND, TRUNCATE, SIGN, FLOOR, and CEILING, which return values of the same data type as the input parameters.

Arguments denoted as *numeric_exp* can be the name of a column, the result of another scalar function, or a *numeric-litera*l, where the underlying data type could be represented as SQL_NUMERIC, SQL_DECIMAL, SQL_TINYINT, SQL_SMALLINT, SQL_INTEGER, SQL_BIGINT, SQL_FLOAT, SQL_REAL, or SQL_DOUBLE.

Arguments denoted as *float_exp* can be the name of a column, the result of another scalar function, or a *numeric-literal*, where the underlying data type can be represented as SQL_FLOAT.

Arguments denoted as *integer_exp* can be the name of a column, the result of another scalar function, or a *numeric-literal*, where the underlying data type can be represented as SQL_TINYINT, SQL_SMALLINT, SQL_INTEGER, or SQL_BIGINT.

The CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP scalar functions have been added in ODBC 3.0 to align with SQL-92.

Function | Description |
---|---|

| Returns the absolute value of |

| Returns the arccosine of |

| Returns the arcsine of |

| Returns the arctangent of |

| Returns the arctangent of the |

| Returns the smallest integer greater than or equal to |

| Returns the cosine of |

| Returns the cotangent of |

| Returns the number of degrees converted from |

| Returns the exponential value of |

| Returns the largest integer less than or equal to |

| Returns the natural logarithm of |

| Returns the base 10 logarithm of |

| Returns the remainder (modulus) of |

| Returns the constant value of pi as a floating-point value. |

| Returns the value of |

| Returns the number of radians converted from |

| Returns a random floating-point value using |

| Returns |

| Returns an indicator of the sign of |

| Returns the sine of |

| Returns the square root of |

| Returns the tangent of |

| Returns |