Thread

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

Darcy Buskermolen <darcy@ok-connect.com> — 2001-11-20T17:07:39Z

At 09:58 AM 11/20/01 -0500, you wrote:
>pgsql-bugs@postgresql.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
>
>