Re: Decimal point and decimal comma

Two methods:

1. on the system level you can change the number format, like changing how you want the date to appear.
2. in SQL there is a FORMAT ex. 'FORMAT 999999.99' 'FORMAT 999,999.99' 'FORMAT 999,999.9' 'FORMAT 999,999' will do rounding

note second method is done in SQL Plus before you run the actual SQL code not within the actual SQL itself

3. Within the Actual SQL you can do this also

see the links below

http://www.cise.ufl.edu/help/database/oracle-docs/server.920/a96540/sql_elements4a.htm

http://www.google.com/search?num=30&hl=en&lr=&ie=UTF-8&q=oracle+sql+format+NUMBER

Stefan Nobis <stefan_at_snobis.de> wrote in message news:<87r7rcqvey.fsf_at_snobis.de>...
> Hi!
>
> I have a problem with Oracle, decimal point/comma and a <censored>
> database admin. My application runs on a german Windows and first
> we had a german Oracle -- so everywhere the decimal comma is used.
>
> Now we got an update to an english version of Oracle. So Oracle
> thinks the value 3,7 means 37 and Windows thinks that values like
> 3.7 means 37.
>
> I use the Oracle ODBC driver and my application is written in
> VB6. Once i tried the Microsoft ODBC driver for Oracle -- it
> converted correct between decimal point/comma but it provides only
> ODBC level 2 but i need level 3 (which is provided by the Oracle
> ODBC driver).
>
> Are there any ways to get the Oracle driver to convert correctly
> between decimal point/comma? Or has anyone any other suggestion to
> the problem? I'm very thankful for any hint!
Received on Fri Jul 16 2004 - 09:55:15 CDT