to_char(timestamp, format) is changing the year!

Поиск
Список
Период
Сортировка
От Stephen Woodbridge
Тема to_char(timestamp, format) is changing the year!
Дата
Msg-id 547B867E.3000805@swoodbridge.com
обсуждение исходный текст
Ответы Re: to_char(timestamp, format) is changing the year!  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: to_char(timestamp, format) is changing the year!  (Steve Atkins <steve@blighty.com>)
Список pgsql-general
Hi,

I am have a problem when I format a timestamp in that it is changing the
year. This can't be right, so either I don't understand or I have found
a nasty corner case bug.

This does not happen on all dates

select '2014-12-31 00:00:00'::timestamp without time zone,
        to_char('2014-12-31 00:00:00'::timestamp without time zone,
'IYYY-MM-DD HH24:MI:SS');

"2014-12-31 00:00:00";"2015-12-31 00:00:00"

It appears that this also happens for all timestamps after "2014-12-28
23:59:59" to the end of the year and then "2015-01-01 00:00:00" is ok again.

I have found this on 9.2 and 9.3.

"PostgreSQL 9.2.9 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit"

"PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit"

Any thoughts on how to work around this?

Thanks,
   -Steve


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: to_char(timestamp, format) is changing the year!