From: Stef <svb@ucs.co.za>
To: pgsql-sql@postgresql.org
Subject: ERROR: Unable to format timestamp; internal coding error
Date: Wed, 23 Jun 2004 18:07:21 +0200
Message-ID: <20040623180721.1bb39778@svb.ucs.co.za> (raw)
Hi all,
I've narrowed my problem down to the following
Java Timestamp that I managed to insert into
a postgres 7.3.4 database :
Timestamp : '1475666-11-30 02:00:00.0'
My problem is, that when I try and select from the table I inserted
this timestamp into, I get the following error :
ERROR: Unable to format timestamp; internal coding error
OR if I try converting it :
=# select date(hpacc_cancelled) from hp_acc;
ERROR: Unable to convert timestamp to date
=# select to_char(hpacc_cancelled,'YYYY') from hp_acc where hpacc_cancelled is not null;
ERROR: to_char(): Unable to convert timestamp to tm
Is there any way I can isolate these and fix them on the database ?
Is there a way to select the values in the table?
Kind Regards
Stefan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: svb@ucs.co.za
Subject: Re: ERROR: Unable to format timestamp; internal coding error
In-Reply-To: <20040623180721.1bb39778@svb.ucs.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox