Re: Storing timestamps in text format

Поиск
Список
Период
Сортировка
От Radosław Smogura
Тема Re: Storing timestamps in text format
Дата
Msg-id a329edbe4cb1bfe58c4941006731d207@smogura-softworks.eu
обсуждение исходный текст
Ответ на Re: Storing timestamps in text format  (Dave Cramer <pg@fastcrypt.com>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Driver work slowly with new update of OpenJDK in Ubuntu..
Следующее
От: Maciek Sakrejda
Дата:
Сообщение: Re: Driver work slow with new upgrade of Openjdk in Ubuntu