johnnymagee69
Programmer
Hi, I'm getting some strange answers when using round().
If I just use a single query select round(20.6348035,6) correctly rounds up and returns 20.634804. However when called as part of a stored procedure round(20.6348035,6) rounds down and returns 20.634803. Has anyone got any idea why round() returns different answers?
If I just use a single query select round(20.6348035,6) correctly rounds up and returns 20.634804. However when called as part of a stored procedure round(20.6348035,6) rounds down and returns 20.634803. Has anyone got any idea why round() returns different answers?