timezone incompatibility

This isn't a jdbc issue so I am forwarding to general.

--Barry

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