From: | Darcy Buskermolen <darcy(at)ok-connect(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | ash(at)freaky-namuh(dot)com |
Subject: | Re: Bug #517: TO_CHAR(timestamp, 'Day') adds extra |
Date: | 2001-11-20 17:07:39 |
Message-ID: | 3.0.32.20011120090738.035d1b20@mail.ok-connect.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Geissel | 2001-11-21 15:21:19 | [JDBC driver] DBConstraint violation within transaction block leaves connection in indeterminate state |
Previous Message | Ashley Cambrell | 2001-11-20 15:13:16 | Re: Bug #517: TO_CHAR(timestamp, 'Day') adds extra whitespace |