pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
ERROR: Unable to format timestamp; internal coding error 2+ messages / 2 participants [nested] [flat]
* ERROR: Unable to format timestamp; internal coding error @ 2004-06-23 16:07 Stef <svb@ucs.co.za> 2004-06-23 16:30 ` Re: ERROR: Unable to format timestamp; internal coding error Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Stef @ 2004-06-23 16:07 UTC (permalink / raw) To: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ERROR: Unable to format timestamp; internal coding error 2004-06-23 16:07 ERROR: Unable to format timestamp; internal coding error Stef <svb@ucs.co.za> @ 2004-06-23 16:30 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2004-06-23 16:30 UTC (permalink / raw) To: Stef <svb@ucs.co.za>; +Cc: pgsql-sql Stef <svb@ucs.co.za> writes: > 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 FWIW, this is fixed in 7.4 and later. > Is there a way to select the values in the table? I'd try something like UPDATE table SET ... WHERE timestamp > '9999-01-01'; regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-06-23 16:30 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-06-23 16:07 ERROR: Unable to format timestamp; internal coding error Stef <svb@ucs.co.za> 2004-06-23 16:30 ` Re: ERROR: Unable to format timestamp; internal coding error Tom Lane <tgl@sss.pgh.pa.us>
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