X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B3FACD1BC4D for ; Wed, 23 Jun 2004 13:08:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21440-01 for ; Wed, 23 Jun 2004 16:08:09 +0000 (GMT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9542DD1B4E5 for ; Wed, 23 Jun 2004 13:08:05 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 620922BE5A for ; Wed, 23 Jun 2004 18:07:49 +0200 (SAST) Received: from ucsns.ucs.co.za ([127.0.0.1]) by localhost (ucsns.ucs.co.za [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22928-04 for ; Wed, 23 Jun 2004 18:07:22 +0200 (SAST) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 084822BDF3 for ; Wed, 23 Jun 2004 18:07:22 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 94F9ADA4CD for ; Wed, 23 Jun 2004 18:07:21 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id 3B102975A0 for ; Wed, 23 Jun 2004 18:07:21 +0200 (SAST) Date: Wed, 23 Jun 2004 18:07:21 +0200 From: Stef To: pgsql-sql@postgresql.org Subject: ERROR: Unable to format timestamp; internal coding error Message-Id: <20040623180721.1bb39778@svb.ucs.co.za> X-Mailer: Sylpheed version 0.9.11claws (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: GFoC95e6r)_TTG>n~=uFLojP=O~4W@Ms]>:.DMm/')(z3\Mwj^XP@? Q:3";lD.OM1"^mDu}2NJ@US:)dO:U*iY5EM50&Tx. X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at ucs.co.za X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/216 X-Sequence-Number: 18161 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