Date issues between versions of PostgreSQL

Started by Jay Schlenkeralmost 24 years ago2 messagesgeneral
Jump to latest
#1Jay Schlenker
jay.schlenker@nisc.cc

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

Attachments:

winmail.datapplication/ms-tnef; name=winmail.datDownload
#2Karel Zak
zakkr@zf.jcu.cz
In reply to: Jay Schlenker (#1)
Re: Date issues between versions of PostgreSQL

On Tue, Jul 09, 2002 at 01:31:55PM -0500, Jay Schlenker wrote:

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

It seems as a timestamp2tm() problem, but I haven't idea why.

How date in your database returns this error?

Karel

--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz