Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Suppress digits after decimal point if integer
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 Wed Nov 15 2000 - 03:19:17 CST