Can some one explain this result. Notice the select.... the result
shows the month followed by 5 spaces and then the comma one
space and the year.
Why are there 5 spaces (ascii 32) after the month? I get the same
thing if I say 'MonthDD, YYYY'. That is no space after the month.
Is this is operating as expected and my expectations are wrong,
point me to the manual pages that explain it.
Mac OSX 10.1.2 postgresql 7.2.1
fifthcolor=# select to_char(termdate, 'Month DD, YYYY') from
employees where code = 'MM';
to_char
--------------------
April 09, 2002
(1 row)
Ted