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

Ashley Cambrell (ash(at)freaky-namuh(dot)com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
TO_CHAR(timestamp, 'Day') adds extra whitespace

Long Description
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.

It's easy enough to fixup on the client side, but it's pretty annoying.

Sample Code
SELECT TO_CHAR('2001-01-01'::date, 'Month');
to_char
-----------
January
(1 row)

SELECT LENGTH('January');
length
--------
7
(1 row)

SELECT LENGTH(TO_CHAR('2001-01-01'::date, 'Month'));
length
--------
9
(1 row)

ELECT TO_CHAR('2001-01-01'::date, 'Day');
to_char
-----------
Monday
(1 row)

SELECT LENGTH('Monday');
length
--------
6
(1 row)

SELECT LENGTH(TO_CHAR('2001-01-01'::date, 'Day'));
length
--------
9
(1 row)

-- notice requested single space after Monday
SELECT LENGTH('Monday ');
length
--------
7
(1 row)

-- notice requested single space after Day
SELECT LENGTH(TO_CHAR('2001-01-01'::date, 'Day '));
length
--------
10
(1 row)

No file was uploaded with this report