Bad timestamp external representation

From: "Denis Khabas" <dkhabas(at)bluecatnetworks(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Bad timestamp external representation
Date: 2004-03-19 16:07:15
Message-ID: 5DEC3FFCDE2F7C4DA45433EE09A4F22C013347E4@colossus.dyadem.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

Hi everyone:

I am using Postgresql 7.3.4 and found a problem inserting "Timestamp" objects through
JDBC Prepared Statements when the time zone is set to Canada/Newfoundland (3 hours and
30 minutes from MGT). I am trying to insert "new Timestamp(0L)" into one of the fields.
The database replies with an error message:

Bad timestamp external representation '1969-12-31 20:30:00.000000-030-30'

Most likely, the database doesn't understand the last part of the timestamp, which is
'-30' (30 minutes). It works properly only with time zones that don't have that additional
half hour difference.

I could not find any useful information regarding that issue.
Any help would be appreciated.


Thanx

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-03-19 16:26:11 7.4.2 Build broken on (Sparc) Solaris 7 and 8
Previous Message Larry Rosenman 2004-03-19 15:57:30 Re: [HACKERS] UnixWare/CVS Tip/initdb.c needs to use

Browse pgsql-jdbc by date

  From Date Subject
Next Message roger.stark 2004-03-20 14:45:46 location of jdbc.jar
Previous Message Fuchs Clemens 2004-03-19 05:44:17 Re: BYTEA with large files leads to OutOfMemory