Re: BUG #16238: Function " to_char(timestamp, text) " doesn't workproperly

Поиск
Список
Период
Сортировка
От Nick Memos
Тема Re: BUG #16238: Function " to_char(timestamp, text) " doesn't workproperly
Дата
Msg-id VI1PR06MB32005E0B676E461C65F983F2C6040@VI1PR06MB3200.eurprd06.prod.outlook.com
обсуждение исходный текст
Ответ на Re: BUG #16238: Function " to_char(timestamp, text) " doesn't work properly  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
Ok thanks Tom!

Αποκτήστε το Outlook για Android

From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Thursday, January 30, 2020 6:27:02 PM
To: memnik@hotmail.com <memnik@hotmail.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #16238: Function " to_char(timestamp, text) " doesn't work properly
 
PG Bug reporting form <noreply@postgresql.org> writes:
> As i noticed the problem is that the function "
> to_char(timestamp, text) "  doesn't work properly. For example this query "
> select to_char('2020-01-29'::date,'Day') " give me this result "Wednesday",
> but this query " select to_char('2020-01-31'::date,'Day') "  give me this
> result "Friday   ".
> So, i guess it is not right to have days with many spaces as a result and
> some days without any space.

No, that's behaving as expected and documented.  If you don't want
fixed-width output, use the FM prefix:

=# select to_char('2020-01-31'::date,'-Day-');
   to_char  
-------------
 -Friday   -
(1 row)

=# select to_char('2020-01-31'::date,'-FMDay-');
 to_char 
----------
 -Friday-
(1 row)

                        regards, tom lane

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

Предыдущее
От: Arseny Sher
Дата:
Сообщение: Re: ERROR: subtransaction logged without previous top-level txn record
Следующее
От: Ted Liu
Дата:
Сообщение: auto_explain logs ERROR: 08P01 for every query using bind variable