User's Guide

Part VI. SQL Anywhere Reference

Chapter 42. Watcom-SQL Functions

Purpose

Numeric functions perform mathematical operations on numerical data types or return numeric information.

Syntax

     Numeric function:
          ABS ( numeric-expr )
          | ACOS ( numeric-expr )
          | ASIN ( numeric-expr )
          | ATAN ( numeric-expr )
          | ATAN2 ( numeric-expr, numeric-expr )
          | CEILING ( numeric-expr )
          | COS ( numeric-expr )
          | COT ( numeric-expr )
          | DEGREES (numeric-expr )
          | EXP ( numeric-expr )
          | FLOOR ( numeric-expr )
          | LOG ( numeric-expr )
          | LOG10 ( numeric-expr )
          | MOD ( dividend, divisor )
          | PI ( * )
          | POWER ( numeric-expr, numeric-expr )
          | RADIANS ( numeric-expr )
          | RAND ( [integer-expr] )
          | REMAINDER ( numeric-expr, numeric-expr )
          | ROUND ( numeric-expr, integer-expr )
          | SIGN ( numeric-expr )
          | SIN ( numeric-expr )
          | SQRT ( numeric-expr )
          | TAN ( numeric-expr )
          | "TRUNCATE" ( numeric-expr, integer-expr )

See also

• Aggregate functions
• String functions
• Date and time functions
• Data type conversion functions
• System functions
• Miscellaneous functions

Description

ABS( numeric-expr ) Returns the absolute value of numeric-expr.

ACOS( numeric-expr ) Returns the arc-cosine of numeric-expr in radians.

ASIN( numeric-expr ) Returns the arc-sine of numeric-expr in radians.

ATAN( numeric-expr ) Returns the arc-tangent of numeric-expr in radians.

ATAN2( numeric-expr1, numeric-expr2 ) Returns the arc-tangent of numeric-expr1/numeric-expr2 in radians.

CEILING( numeric-expr ) Returns the ceiling (smallest integer not less than) of numeric-expr.

COS( numeric-expr ) Returns the cosine of numeric-expr, expressed in radians.

COT( numeric-expr ) Returns the cotangent of numeric-expr, expressed in radians.

DEGREES( numeric-expr ) Converts numeric-expr, from radians to degrees.

EXP( numeric-expr ) Returns the exponential function of numeric-expr.

FLOOR( numeric-expr ) Returns the floor (largest integer not greater than) of numeric-expr.

LOG( numeric-expr ) Returns the logarithm of numeric-expr.

LOG10( numeric-expr ) Returns the logarithm base 10 of numeric-expr.

MOD( dividend, divisor ) Returns the remainder when dividend is divided by divisor. Division involving a negative dividend will give a negative or zero result. The sign of the divisor has no effect.

PI( * ) Returns the numeric value PI.

POWER ( numeric-expr1, numeric-expr2 ) Raises numeric-expr1 to the power numeric-expr2.

RADIANS ( numeric-expr ) Converts numeric-expr, from degrees to radians.

RAND ( [ integer-expr ] ) Returns a random number in the interval 0 to 1, with integer-expr as an optional seed.

REMAINDER( dividend, divisor ) Same as the MOD function.

ROUND ( numeric-expr, integer-expr ) Rounds numeric-expr to integer-expr places after the decimal point. A positive integer determines the number of significant digits to the right of the decimal point; a negative integer, the number of significant digits to the left of the decimal point.

SIGN( numeric-expr ) Returns the sign of numeric-expr.

SIN( numeric-expr ) Returns the sine of numeric-expr, expressed in radians.

SQRT( numeric-expr ) Returns the square root of numeric-expr.

TAN( numeric-expr ) Returns the tangent of numeric-expr, expressed in radians.

"TRUNCATE" ( numeric-expr, integer-expr ) Truncates numeric-expr at integer-expr places after the decimal point. A positive integer determines the number of significant digits to the right of the decimal point; a negative integer, the number of significant digits to the left of the decimal point.

The double quotes are required because of a keyword conflict with the TRUNCATE TABLE statement.