Re: TIMESTAMP WITHOUT TIME ZONE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: TIMESTAMP WITHOUT TIME ZONE
Дата
Msg-id 27492.1165965921@sss.pgh.pa.us
обсуждение исходный текст
Ответ на TIMESTAMP WITHOUT TIME ZONE  ("Randy Shelley" <randy.shelley@gmail.com>)
Ответы Re: TIMESTAMP WITHOUT TIME ZONE  (Richard Troy <rtroy@ScienceTools.com>)
Список pgsql-general
"Randy Shelley" <randy.shelley@gmail.com> writes:
> The java.sql.Timestamp does not store any timezone info, just nano seconds
> from a date.

One would hope that it's implicitly referenced to GMT, though, not some
free-floating value that means who-knows-what.

I think your fundamental error is in using timestamp without time zone
in the database.  Try with-time-zone if you want consistent results
across clients in different zones.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeremy Harris
Дата:
Сообщение: Re: Postgres friendly RegEx?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Statement timeout not working on broken connections with active queries