I asked:
>> to_char(0,'9999.99')
>>
>>returns .00 rather than 0.00.
Dave Smith replied:
> to_char(0,'9990.00')
> ?
Thanks Dave, that's embarrassingly obvious...
I note that the examples in the documentation don't have a 0 before the
decimal point, e.g. this one
to_char(148.5, 'FM999.990') '148.500'
I imagine that in most cases people do want '0.000' rather than '.000',
so perhaps these examples should be changed to, in this case, 990.000.
Regards,
--Phil.
