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



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html