Mathematical Functions in SQL

Linklist

1. ABS - absolute value
2. CEIL - round to next bigger value
3. FLOOR - round to next lower value
4. HEX - hexadecimal value
5. MOD - modulo
6. ROUND - round a value
7. SQRT - queare root
8. TAN - tangens
9. TRUNC - round to integer

ABS - absolute value

Syntax

ABS( Formula )

Description

ABS retuns the absolute value fo the argument : if X<0 then (-1)*X else X.

CEIL - round to the next bigger value

DB2

Syntax

CEIL( Formula )

Description

Rounds the argument to the next bigger integer value.

HEX - Hexadecimal-Code

Syntax

HEX( Formula )

Description

Returns the HEX-value of the argument.

FLOOR - round to the next lower value

DB2

Syntax

FLOOR( Formula )

Description

Rounds the argument to the next lower interger value.

MOD - modulo / Restwert

Syntax

MOD( Formula1, Formula2 )

Description

MOD returns the rest of an division of two arguments.

ROUND - round a value

Syntax

ROUND( Formula [, Integer ] )

Description

Rounds the argument to the next floating point number with specifyed number of decimals. If the oprional number of decimals in not given, then the result would be an integer.

SQRT - square root

Syntax

SQRT( Formula )

Description

Returns the square root of the argument.

TAN - tangens

Syntax

TAN( Formula )

Description

Returns the tangens of the argument.

TRUNC - make an Integer

Informix

Syntax

TRUNC( Formel )

Description

TRUNC rounds the argument to the next integer.