Re: Bug #517: TO_CHAR(timestamp, 'Day') adds extra

At 09:58 AM 11/20/01 -0500, you wrote:
>pgsql-bugs(at)postgresql(dot)org writes:
>> Using the postgresql TO_CHAR function with Day, DAY, day, Month, MONTH
or month as the text argument, extra whitespace is appended to the output.
>
>AFAIK this is the intended behavior. There's an FM modifier that you
>add to the format item to suppress extra whitespace. See the examples
>in the manual.
>
>(Yes, this formatting language is plenty ugly, but don't blame us ...
>we're just trying to be Oracle-compatible with it ...)

In case you are short an Oracle manual:
MONTH Month name, padded with blanks to 9 characters

SQL> select to_char(to_date('2001-01-01','yyyy-mm-dd'),'month') 2 from dual;
TO_CHAR(T
---------
january

>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>