OraFAQ Forum: SQL & PL/SQL » Round Down Hundered..Kindly Help.

Home » SQL & PL/SQL » SQL & PL/SQL » Round Down Hundered..Kindly Help.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Round Down Hundered..Kindly Help. [message #24942]

Mon, 17 March 2003 09:50

Muzzammil
Messages: 99
Registered: February 2003

Member

Hi Experts,

I want to make round down hundered.

Ex. If i entered value from 101 to 199 it should round down to 100.

The following statement is rounding up to Hundered..

SELECT TRUNC(your_number+99,-2) FROM DUAL;

Kindly help.

Thanks,
Syed Muzzammil.

Report message to a moderator

Re: Round Down Hundered..Kindly Help. [message #24943 is a reply to message #24942]

Mon, 17 March 2003 09:58

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

_quote:
----------------------------------------------------------------------

Hi Experts,

I want to make round down hundered.

Ex. If i entered value from 101 to 199 it should round down to 100.

The following statement is rounding up to Hundered..

SELECT TRUNC(your_number+99,-2) FROM DUAL; 

Kindly help.

Thanks,
Syed Muzzammil.

----------------------------------------------------------------------

SQL> SELECT n
  2  ,      <font color=red>TRUNC(</font>n<font color=red>,-2)</font> round_down
  3  FROM   t
  4  /
  
         N ROUND_DOWN
---------- ----------
        99          0
       100        100
       101        100
       111        100
       149        100
       150        100
       151        100
       177        100
    183.62        100
       199        100
       200        200
      1234       1200
  
12 rows selected.
  
SQL>

Good luck,

A

Report message to a moderator

Re: Round Down Hundered..Kindly Help. [message #24958 is a reply to message #24942]

Mon, 17 March 2003 22:28

Muzzammil
Messages: 99
Registered: February 2003

Member

Thanks Mr. Atr Metzer

Report message to a moderator

Previous Topic:	Package - Procedure
Next Topic:	Outer join with a subquery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 19 22:01:47 CDT 2025