How to convert number in SQL?
799251Sep 30 2010 — edited Sep 30 2010How can i convert the number in SQL?
The problem is i use .NET and the Oraclenumber seems to be too big.
Number in Database----------------What i get when i Select
-----------'12'--------------------------------------'12'
-----------'12,1'------------------------------------'12,10' <---This 0 should not be there
-----------'12,12'-----------------------------------'12,12'
-----------'12,123'---------------------------------'12,1230' <---This 0 should not be there
-----------'12,1234'-------------------------------- '12,1234'
I dont know why this happens?
Now i tried to Select with to_char(COLUMN1), but when i have values like '0,15' in the Database i get in Select ',15' when i convert with to_char?
Does anyone know a solution??
Kind regards
Simon
Edited by: user3654758 on 30.09.2010 02:02