CODEWITHSUNDEEP
sql
Rickey Alterman
Rickey Alterman

Reputation: 11

Round() is not giving the desired result

SELECT ROUND(CAST (6348.4644 AS decimal (6,2)),1)

The result is: 6348.50

Desired result: 6349.00

Upvotes: 0

Views: 33

Answers (1)

Oto Shavadze
Oto Shavadze

Reputation: 42763

If you want always rounding to upper side, then use ceiling function

SELECT CAST ( ceiling( 6348.4644 ) AS decimal (6,2) )

Upvotes: 1

Related Questions