Re: international format

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Mon, 26 Mar 2001 16:55:24 +0200
Message-ID: <99nl8t$kek$1_at_s1.read.news.oleane.net>

""Zimmer, Peter"" <Peter.Zimmer_at_dresdner-bank.com> a écrit dans le message news: B575BF98FA79D4119BD20008C7A4516523451C_at_ffz00za9.wwz1me.mail.dresdner.net...
> how can i convert a varchar2 with 99,999.99 OR 99.999,99 to number 99999,99
> ?
>
> --
> Posted from purveyor7.dresdnerbank.de [193.194.7.53]
> via Mailgate.ORG Server - http://www.Mailgate.ORG

You can do something like:

v815> select to_char(to_number('99,999.99',

  2                           '99G999D99',
  3                           'NLS_NUMERIC_CHARACTERS=''.,'''),
  4                 '99999D99','NLS_NUMERIC_CHARACTERS='',.''')

  5 from dual
  6 /

TO_CHAR(T

---

 99999,99

1 row selected.

--
Have a nice day
Michel

Received on Mon Mar 26 2001 - 16:55:24 CEST