to_char(0.1) result is ,1 but must be 0,1 [message #399775] |
Fri, 24 April 2009 00:46  |
littleant
Messages: 3 Registered: April 2009 Location: Estonia
|
Junior Member |
|
|
In Estonia is float numbers format allways with leading zero ( 0,1 ). My NLS settings are:
NLS_TERRITORY = ESTONIA
NLS_LANGUAGE = ESTONIAN
but float numbers are converted to text without leading zero.
select to_char(0.1) from dual;
result: ,1
This is absurd when I need to insert number format everywhere, when I'm using my territory NLS.
so, how can I set the default number conversion format?
|
|
|
|
|
Re: to_char(0.1) result is ,1 but must be 0,1 [message #399783 is a reply to message #399778] |
Fri, 24 April 2009 01:25   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
This is not absurd.
SQL is a language to extract data from a database, so your query fetches what's in the db. In the database, your value is stored as a number.
Now it's up to your front-end application to display the data fetched through SQL in the way you desire.
|
|
|
|
|
|