Brendan Jurd escreveu:
> 2009/7/31 Euler Taveira de Oliveira <euler@timbira.com>:
>> Brendan Jurd escreveu:
>>> Limiting to two exponent digits also has the nice property that the
>>> output always matches the length of the format pattern:
>>>
>>> 9.99EEEE
>>> 1.23E+02
>>>
>> I don't think neglecting to represent a valid number is a "nice property".
>> What does the length of format pattern have to do with output format?
>
> Most of the format patterns in to_char() are chosen to match the
> length of their expected output. The output of "DD" is two
> characters, "Mon" is three and so on.
>
Brendan, the main point of to_*() functions is Oracle-compatibility. So let's
just do it. No matter it seems bizarre (like 999.99EEEE).
> That's why the scientific notation pattern is "EEEE" and not just "E".
>
I don't know. Ask Oracle. ;) We don't need to bother with that. Let's just be
compatible.
-- Euler Taveira de Oliveira http://www.timbira.com/