| 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: | Whole Thread | Raw Message | 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? |