Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Getting the 2 first numbers ???

Getting the 2 first numbers ???

From: Bruno Baguette <bruno.baguette_at_netcourrier.com>
Date: Wed, 28 Mar 2001 21:54:59 +0200
Message-ID: <99tfdh$c03$2@news.worldonline.be>

Hello,

I'm using Oracle 8 :

I would like to get the 2 first numbers of the floating part of the result of a division :

12978892/97 = 133803.010309

The numbers i would like to get are "01" (in others words the 2 first numbers after the decimal separator)

I know that i can use plenty of SUBSTR but i think that's not a good answer because in the french Oracle version, the decimal separator is "," and in the US Oracle version it's "."....

So, what can i do to get theses 2 numbers ???

Thanks a lot !



Bruno BAGUETTE - bruno.baguette_at_netcourrier.com Received on Wed Mar 28 2001 - 13:54:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US