Abs function is not working correctly

Prasanna · Post by **Prasanna** » Thu Jul 01, 2004 3:04 am

Abs function is not working correctly.
For ex:
Abs(-12.56) returns 13.00.

ANSHULA · Post by **ANSHULA** » Thu Jul 01, 2004 5:33 am

What is the definition (SQL type, length and scale) of input and output columns ?
If output column is declared Numeric without scale specification, then
Abs(-12.56) returns 13.00
If proper scale specified, then
Abs(-12.56) returns correct value.

Prasanna · Post by **Prasanna** » Fri Jul 02, 2004 6:08 am

ANSHULA wrote:What is the definition (SQL type, length and scale) of input and output columns ?
If output column is declared Numeric without scale specification, then
Abs(-12.56) returns 13.00
If proper scale specified, then
Abs(-12.56) returns correct value.

Output Column has been delcared as Numeric with length 20 and scale 6.