Re: Date issues between versions of PostgreSQL - Mailing list pgsql-general

From Karel Zak
Subject Re: Date issues between versions of PostgreSQL
Date
Msg-id 20020710102138.A28452@zf.jcu.cz
Whole thread Raw
In response to Date issues between versions of PostgreSQL  ("Jay Schlenker" <jay.schlenker@nisc.cc>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Sam Liddicott"
Date:
Subject: Re: 7.2.1 optimises very badly against 7.2
Next
From: Curt Sampson
Date:
Subject: Re: I am being interviewed by OReilly