Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #517: TO_CHAR(timestamp, 'Day') adds extra whitespace - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #517: TO_CHAR(timestamp, 'Day') adds extra whitespace
Date
Msg-id 29384.1006268314@sss.pgh.pa.us
Whole thread Raw
In response to Bug #517: TO_CHAR(timestamp, 'Day') adds extra whitespace  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> Using the postgresql TO_CHAR function with Day, DAY, day, Month, MONTH or month as the text argument, extra
whitespaceis 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 ...)

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #517: TO_CHAR(timestamp, 'Day') adds extra whitespace
Next
From: Darcy Buskermolen
Date:
Subject: Re: Bug #517: TO_CHAR(timestamp, 'Day') adds extra