Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Suppress digits after decimal point if integer
rtrim (to_char (abc), '.00')
orauser_at_my-deja.com wrote:
>
> Hello,
>
> Is it possible to have a to_char number format to only
> print the .xx part of a number, if it is not
> an integer?
>
> i.e, i want:
>
> 12345
> or 12345.66
> but never
> 12345.00
>
> Thanks in advance for your help.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Dec 03 2000 - 01:36:37 CST