Link to home
Create AccountLog in
Avatar of claghorn
claghorn

asked on

Oracle TO_NUMBER function.

HR@ORCL> select to_number('123.88','999.99') from dual;

TO_NUMBER('123.88','999.99')
----------------------------
                      123,88

Why do I get 123,88?
Why not 123.88?
Avatar of anumoses
anumoses
Flag of United States of America image

You should get

TO_NUMBER('123.88','999.99')
123.88
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account