Re: Help with trimming value in PL/SQL
From: Enrique Iglesias <enrique.iglesias_at_sympatico.ca>
Date: Sun, 05 Dec 1999 03:50:52 GMT
Message-ID: <3849E258.9C347E29_at_sympatico.ca>
This will work:
Date: Sun, 05 Dec 1999 03:50:52 GMT
Message-ID: <3849E258.9C347E29_at_sympatico.ca>
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 asReceived on Sun Dec 05 1999 - 04:50:52 CET1043.99
434345353.9943242
564.99245453How 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?