Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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
>
>

pgsql-bugs by date

Next:From: Adrian GeisselDate: 2001-11-21 15:21:19
Subject: [JDBC driver] DBConstraint violation within transaction block leaves connection in indeterminate state
Previous:From: Ashley CambrellDate: 2001-11-20 15:13:16
Subject: Re: Bug #517: TO_CHAR(timestamp, 'Day') adds extra whitespace

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group