Re: Help with trimming value in PL/SQL

This will work:

  1 select floor ((246.9908 - floor (246.9908)) * 100)   2* from dual

FLOOR((246.9908-FLOOR(246.9908))*100)

                                   99

Rgds,
Enrique

Brian Howard wrote:

> I have a column with numbers such as
>
> 1043.99
> 434345353.9943242
> 564.99245453
>
> How do I trim the column in order to get just the 99(hypothetically) which
> always falls as the first two digits after the decimal. In other words I
> want it to return the first two digits after the decimal point (without
> rounding first). Suggestions?
Received on Sat Dec 04 1999 - 21:50:52 CST