FM suffix in to_char Y/YY/YYY still screwy

Поиск
Список
Период
Сортировка
От Tom Lane
Тема FM suffix in to_char Y/YY/YYY still screwy
Дата
Msg-id 21721.1270673174@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: FM suffix in to_char Y/YY/YYY still screwy
Re: FM suffix in to_char Y/YY/YYY still screwy
Список pgsql-hackers
I thought we'd fixed this ...

regression=# select to_char('2009-01-01'::date, 'YY');to_char 
---------09
(1 row)

regression=# select to_char('2009-01-01'::date, 'FMYY');to_char 
---------09
(1 row)

Not a lot of zero suppression happening there :-(.

I believe the correct fix is to reduce the year mod 100 (or 10 or 1000)
before feeding it to snprintf, rather than playing games with printing
only part of the result string as the original and current code try to
do.
        regards, tom lane


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

Предыдущее
От: Dhiraj Lohiya
Дата:
Сообщение: Enhancing phonetic search support for more languages - GSoC 2010
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Enhancing phonetic search support for more languages - GSoC 2010