Problem converting varchar2 to number
678888Jan 8 2009 — edited Jan 8 2009I am having difficulty converting strings to numbers. On my Oracle 9.2 server, the following gives me an ORA-1722 error:
SELECT TO_NUMBER('1.2') FROM DUAL
Apparently this is because my server is setup to use the greek number format (comma instead of decimal point) and replacing '1.2' above with '1,2' will work correctly.
Is there some culture-independent way for me to convert strings with decimal points to the number type, so that my application will not have to depend on the regional settings of the server?
Thank you.