Good to know.

oracle behaves the same.

declare

round1a binary_float := 165.755;

round2a binary_float := 165.555;

round1b float := 165.755;

round2b float := 165.555;

begin

dbms_output.PUT_LINE (ROUND(round1a,2));

dbms_output.PUT_LINE (ROUND(round2a,2));

dbms_output.PUT_LINE (ROUND(round1b,2));

dbms_output.PUT_LINE (ROUND(round2b,2));

end;

165.76

165.55

165.76

165.56

Rob