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 |
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 |