OraFAQ Forum: SQL & PL/SQL » How to convert float value to character with a change of '.' to ':'

Home » SQL & PL/SQL » SQL & PL/SQL » How to convert float value to character with a change of '.' to ':'

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to convert float value to character with a change of '.' to ':' [message #1910]

Mon, 10 June 2002 07:25

Amarnath Revuri
Messages: 3
Registered: April 2002

Junior Member

Can any one pls tell me an sql query how to convert float value to character with a change of '.' to ':'

Example
float value is 120.34
required char value 120:34

Report message to a moderator

Re: How to convert float value to character with a change of '.' to ':' [message #1913 is a reply to message #1910]

Mon, 10 June 2002 10:32

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

sql>select c, replace(to_char(c), '.', ':') from t;
 
        C REPLACE(TO_CHAR(C),'.',':')
--------- ----------------------------------------
   120.34 120:34

Report message to a moderator

Previous Topic:	Re: show init.ora parameters during session?
Next Topic:	PL/SQL or Perl?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 12:39:15 CDT 2024