to_char problem

Поиск
Список
Период
Сортировка
От postgresql
Тема to_char problem
Дата
Msg-id 20020413163554.540AE475902@postgresql.org
обсуждение исходный текст
Ответы Re: to_char problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
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




В списке pgsql-sql по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: deletions on master table takes for ever...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: to_char problem