Question

0

Hi,

I need help in Rounding,

value >5 increases to 1.

Eg: 72.70 should Round to 73.0

Could anyone please help me.

Thanks in Advance. TDHelp

flag	asked Jan 7 at 22:26 TDHELP 5●1

Monis Iqbal · Accepted Answer · 2010-01-13 10:03:42Z UTC

0

I think double casting should do the trick for you:

select cast( cast(72.70 as decimal(2)) as decimal(3,1))

Result: 73.0

answered Jan 13 at 10:03

Monis Iqbal
110●1●1●9

Thanks a lot, this helped me a lot. The below thing worked instead of 3,1 select cast( cast(72.70 as decimal(2)) as decimal(4,1)) – TDHELP Jan 14 at 3:25

Carlos A. Ibarra · Answer 2 · 2010-01-07 22:29:57Z UTC

0

Rounding is the default behavior when casting to a lower precision decimal. For example:

select cast(72.7 as decimal(2))

Answer: 73

answered Jan 7 at 22:29

Carlos A. Ibarra♦♦
120●7

	Thanks for the reply, But I want in this format only 73.0 When I try in the query with decimal(2), I am getting Numeric overflow occured during computation. – TDHELP Jan 8 at 0:36
	Try a larger number like decimal(10) then. – Carlos A. Ibarra♦ Jan 9 at 23:24

Rounding increase by 1

2 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged rounding or ask your own question.

Welcome to TeradataQuestions

Useful links