Received: from symcom.com (unknown [209.11.41.82]) by postgresql.org (Postfix) with ESMTP id 540AE475902 for ; Sat, 13 Apr 2002 12:35:54 -0400 (EDT) Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Sat, 13 Apr 2002 12:57:25 -0400 Date: Sat, 13 Apr 2002 12:57:25 -0400 From: "postgresql" To: "PgSQL-SQL" Subject: to_char problem X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org Message-Id: <20020413163554.540AE475902@postgresql.org> X-Archive-Number: 200204/169 X-Sequence-Number: 7433 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