From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | Jay Schlenker <jay(dot)schlenker(at)nisc(dot)cc> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Date issues between versions of PostgreSQL |
Date: | 2002-07-10 08:21:39 |
Message-ID: | 20020710102138.A28452@zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
From | Date | Subject | |
---|---|---|---|
Next Message | Curt Sampson | 2002-07-10 08:24:18 | Re: I am being interviewed by OReilly |
Previous Message | Jürgen Mischke | 2002-07-10 07:55:32 | Re: update problem? |