Date issues between versions of PostgreSQL

Поиск
Список
Период
Сортировка
От Jay Schlenker
Тема Date issues between versions of PostgreSQL
Дата
Msg-id MPEHIMIJOIOPIMALPCBNEEPLCKAA.jay.schlenker@nisc.cc
обсуждение исходный текст
Ответы Re: Date issues between versions of PostgreSQL  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-general
Good Afternoon,

We have upgraded from version 7.1.4 to 7.2.1 and have noticed some issues
dealing with the way dates are handled (still tracking this down).  One of
the errors that we are seeing comes from this statement--

select to_char (hiredate, 'MM/DD/YYYY') from employees;

The error we receive is--
ERROR:  Unable to convert date to tm

This worked fine on the older version of the DB and it also works on other
date columns in the same table on the new version, although the year in that
column is the same throughout the table if that makes any difference (our
birthdate field uses 2002 as the year so nobody gets offended trying to find
out their birthday).  Have any of you run into this situation?

Thanks,
Jay Schlenker
GUI/Web Development Team Leader
RD&Q--Mandan, ND
National Information Solutions Cooperative


Вложения

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

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: Linux 7.1 dependency problems
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: Redhat/glibc and postgre time "bug"