Date issues between versions of PostgreSQL

From: "Jay Schlenker" <jay(dot)schlenker(at)nisc(dot)cc>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Date issues between versions of PostgreSQL
Date: 2002-07-09 18:31:55
Message-ID: MPEHIMIJOIOPIMALPCBNEEPLCKAA.jay.schlenker@nisc.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
winmail.dat application/ms-tnef 1.9 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Srinivasa Rao Chava 2002-07-09 18:34:21 Problem with postgresql 7.2.1
Previous Message Lamar Owen 2002-07-09 18:27:34 Re: Linux 7.1 dependency problems