Re: Date issues between versions of PostgreSQL

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

In response to

Browse pgsql-general by date

  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?