Rounding Fun

Question

Rounding Fun

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
April 27, 2020 at 12:00 am

#3744739

Comments posted to this topic are about the item Rounding Fun

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Bob Razumich SSCrazy Points: 2140 More actions · Answer 1

Fun question to start the week. Fun working with negative numbers in functions; one always needs to think a bit out of the box.

dale_berta Ten Centuries Points: 1322 More actions · Answer 2

dale_berta

Ten Centuries

Points: 1322

April 27, 2020 at 12:50 pm

#3746621

Missed the "-"; that makes all the difference.

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 3

Thanks Steve for this question. You can also try this:

SELECT ROUND(-7.7, 0, 1) as Round_truncated, CEILING(-7.7) as 'Ceiling';  
GO

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 4

Steve Jones - SSC Editor

SSC Guru

Points: 736173

April 27, 2020 at 3:17 pm

#3746693

Write me a question. George 🙂

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 5

Steve Jones - SSC Editor wrote:

Write me a question. George 🙂

Sorry, I have no question, I just wanted to point out the 3rd parameter for the ROUND function;-)

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 6

confidently answer question

get it wrong

re-read question

notice the "-"

facepalm

drink more coffee....

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

Stewart "Arturius" Campbell SSC Guru Points: 72624 More actions · Answer 7

Nice one, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”