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.

Report message to a moderator

Previous Topic: How can i make a running number in a View Table
Next Topic: query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 01:20:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.