Abs function is not working correctly.
For ex:
Abs(-12.56) returns 13.00.
Abs function is not working correctly
Moderators: chulett, rschirm, roy
Output Column has been delcared as Numeric with length 20 and scale 6.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.