Hi Dave,
in my opinion it is a jdbc feature (maybe not a bug), as it is the driver
that subtracts the two hours from the test date and writes the changed date
into the database. Performing a SELECT on this date doesn't re-add the 2
hours, so I see a wrong date.
Other jdbc drivers like for oracle, mysql, sapdb ... write the date as is
into the database.
Operating system is Suse 7.0.
thanks for answering
Wolfgang
-----Ursprüngliche Nachricht-----
Von: Dave Cramer [mailto:Dave@micro-automation.net]
Gesendet am: Freitag, 21. Juni 2002 11:14
An: Winter, Wolfgang
Cc: pgsql-jdbc@postgresql.org
Betreff: Re: [JDBC] timezone incompatibility
Wolfgang,
This isn't a jdbc issue, I would try the hackers list, or the general
list.
Out of curiosity are you using RedHat? They broke time. You can try
complaining to them if this is the case.
Dave
On Fri, 2002-06-21 at 02:46, Winter, Wolfgang wrote:
> Hi,
>
> I'm testing our auto-configuration persistence framework (acp) against
> several databases and now that it comes to PostgreSQL, I run into a
timezone
> incompatibility compared to other jdbc-drivers/databases. The framework
> tests the database specific datatypes by inserting a value, retrieving it
> and comparing the result. Here is the result for timestamp:
>
> Insert and Retrieve of SQLType 93 test value <Sun Jun 20 20:16:54 CEST
> 1756> failed. Retrieved after insert: <Sun Jun 20 18:16:54 CEST 1756>
>
> I tried it with a test value in 1992 and the test passes.
> Okay, the docs say:
> "PostgreSQL uses your operating system's underlying features to provide
> output time-zone support, and these systems usually contain information
for
> only the time period 1902 through 2038 (corresponding to the full range of
> conventional Unix system time)."
>
> But nevertheless, I feel sick with this behaviour, to me it seems not to
be
> correct and it makes PostgreSQL incompatible to other databases. The
> databases I have tested so far retrieve the correct date before 1902.
>
>
> regards
> Wolfgang
>
>
>
> Dr. Wolfgang Winter
> LogiTags Systems
> http://www.logitags.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
