Round Function

sonia.sardana

New Member

Join Date: Jul 2006

Posts: 95
#1

Round Function

Feb 15 '08, 06:59 PM

1) Select round(34.567,2)
ANSWER-34.570

2) select round(34.5321,2 )
ANSWER- 34.5300

I want only 34.53 .Not 34.5300.
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Feb 15 '08, 08:26 PM

Originally posted by sonia.sardana

1) Select round(34.567,2)
ANSWER-34.570

2) select round(34.5321,2 )
ANSWER- 34.5300

I want only 34.53 .Not 34.5300.

The value is the same. If the reason is for display purposes, you can either parse (substring) it, or handle it on your GUI side and not stress your server.

-- CK
Comment

Comment