SQL> select floor(col1/100) from test_tb;

> -----Original Message-----
> From: Benny Pei [SMTP:[Email Address Removed] Sent: Tuesday, July 10, 2001 2:56 PM
> To: LazyDBA.com Discussion
> Subject: a math question
>
> This is going to be a dumb one. :)
>
> I have a column declared as int. I want to divide
> int/100 but the number comes up with a decimal point.
> How do I get only the integer part of this division?
>
> e.g.
>
> col1
> ----
> 100
> 101
> 102
>
> SQL> select col1/100 from test_tb;
>
> col1/100
> --------
> 1
> 1
> 1
>
> *NOT*
> col1/100
> --------
> 1
> 1.01
> 1.02
>
> thanks,
>
> benny
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page