Re: Storing timestamps in text format - Mailing list pgsql-jdbc

From Radosław Smogura
Subject Re: Storing timestamps in text format
Date
Msg-id a329edbe4cb1bfe58c4941006731d207@smogura-softworks.eu
Whole thread Raw
In response to Re: Storing timestamps in text format  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
On Wed, 1 Dec 2010 16:36:18 -0500, Dave Cramer <pg@fastcrypt.com> wrote:
> FWIW, timestamps with time zones are pretty useless artifacts since
> they are not monotonic, due to to daylight savings time. Further
> exacerbating the problem of DST is that it is not the same everywhere.
> Some people observe it, some don't.
>
> Dave

I generally doesn't treat TIMESTAMP TZ, as some information about Time
Zone, but like UTC time (it's even good way, because PG doesn't store TZ
info), until PG will not encode tstz with wrong offset, should be no
problem.

In any case I can't find any info about true errors with JDBC and
PostgreSQL. If there are I really would like to read it.
--
----------
Radosław Smogura
http://www.softperience.eu

pgsql-jdbc by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Driver work slowly with new update of OpenJDK in Ubuntu..
Next
From: Maciek Sakrejda
Date:
Subject: Re: Driver work slow with new upgrade of Openjdk in Ubuntu