Re: Help with trimming value in PL/SQL
From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 3 Nov 1999 09:30:10 GMT
Message-ID: <01bf25de$b5649ae0$190114c1_at_sister.grant.UUCP>
Date: 3 Nov 1999 09:30:10 GMT
Message-ID: <01bf25de$b5649ae0$190114c1_at_sister.grant.UUCP>
abs(trunc(mod(your_number, 1), 2))
If You have only positive numbers, abs is redundant.
-- Alexander I.Doroshko, aid_at_grant.kharkov.ua * Bank "Grant", Kharkov, Ukraine Brian Howard <bkhoward_at_flash.net> wrote in article <WBKT3.1978$w9.224641_at_news.flash.net>...Received on Wed Nov 03 1999 - 10:30:10 CET
: 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?