Different behavior on ROUND() based on number format

Asked Jun 21 '23 at 14:50

Active Jun 21 '23 at 18:58

Viewed 39 times

Executing the following:

SELECT ROUND(0.825,2)

RETURNS 0.830

Executing the following:

SELECT ROUND(CAST(0.825 AS FLOAT),2)

RETURNS 0.82

How is this behavior explained and how can be overcomed when I want to round a float field to 2 decimals?

edited Jun 21 '23 at 18:58

Dale K

asked Jun 21 '23 at 14:50

rpd

1

The number in `SELECT ROUND(0.825,2)` isn't a float. That number *can't* be represented as a float – Panagiotis Kanavos Jun 21 '23 at 14:53
2

Likely the same as this very recent question https://stackoverflow.com/q/76523794/73226 – Martin Smith Jun 21 '23 at 14:54
Yes, seems exactly so – rpd Jun 21 '23 at 14:56
@ThomA I changed your answer-in-a-comment to an answer. Upvote it, or add your own and I'll upvote it and we can close this one as a dupe. – David Browne - Microsoft Jun 21 '23 at 17:17

0 Answers0