Home » RDBMS Server » Server Administration » Re: varchar2 to number conversion
Re: varchar2 to number conversion [message #375131] Mon, 30 July 2001 07:39
Sivakumar M
Messages: 1
Registered: July 2001
Junior Member
Regarding the conversion of Varchar2 to number you can use TO_NUMBER(field_name) function,

SELECT TO_NUMBER('20010728140710') FROM DUAL;

(or)

In your Java Programe you can get directly the varchar2 field using getString("field_name") and convert it into Double.parseDouble(String variable_name). (You can use double or float)

Hope this solves your problem.
Previous Topic: How can i make a running number in a View Table
Next Topic: query
Goto Forum:
  


Current Time: Tue Dec 24 06:23:07 CST 2024