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
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 |
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 |