OraFAQ Forum: SQL & PL/SQL » number to character conversion

Home » SQL & PL/SQL » SQL & PL/SQL » number to character conversion (oracle 11g)

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

number to character conversion [message #628685]

Thu, 27 November 2014 01:06

b_chugh
Messages: 68
Registered: August 2005
Location: delhi

Member

Hi All

I want to get the output as 0.00 when I pass a number as 0. I have tried to_char(TestNum,'9999.99') but it gives the outout as .00 not 0.00.

Please suggest.

Thank You
b_chugh

Report message to a moderator

Re: number to character conversion [message #628688 is a reply to message #628685]

Thu, 27 November 2014 01:27

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try

9990.00

Or, even better

9990D00

[Updated on: Thu, 27 November 2014 01:27]

Report message to a moderator

Re: number to character conversion [message #628689 is a reply to message #628688]

Thu, 27 November 2014 01:31

b_chugh
Messages: 68
Registered: August 2005
Location: delhi

Member

I have used 9990.99 and it is working fine. Thank you so much for the quick reply.

Is it fine to use 9990.99 instead of 9990.00?

Thank You

Report message to a moderator

Re: number to character conversion [message #628693 is a reply to message #628689]

Thu, 27 November 2014 01:46

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is better you use the format mask that clearly shows what you want.
So put 0 where you want mandatory digits and 9 when this is optional.

Report message to a moderator

Re: number to character conversion [message #628700 is a reply to message #628693]

Thu, 27 November 2014 03:01

b_chugh
Messages: 68
Registered: August 2005
Location: delhi

Member

Got it. Thank You!!

Report message to a moderator

Previous Topic:	creating view based on availability of data in 2 tables
Next Topic:	Return individuals most regular areas

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 07:11:25 CDT 2024