4 Functions Functions manipulate data and return a result. In addition to an alphabetical listing of all functions, this chapter contains an overview of functions including: Numeric Functions Bitwise Functions Character Functions Returning Character Values Character Functions Returning Number Values String Functions LOB Functions NLS Character Set Functions General Comparison Functions Null-Related Comparison Functions Conversion Functions Datetime Functions Aggregate Functions Analytic Functions Encoding and Decoding Functions User and Session Functions Function in TimesTen Scaleout Numeric Functions Numeric functions accept numeric input and return numeric values. The numeric functions are: ABS ACOS ASIN ATAN ATAN2 COS COSH CEIL EXP FLOOR LN LOG MOD POWER ROUND (Expression) SIGN SIN SINH SQRT TAN TANH TRUNC (Expression)