Re: Timezone information

Поиск
Список
Период
Сортировка
От Dev Kumkar
Тема Re: Timezone information
Дата
Msg-id CALSLE1O5L=tATwhvsC+oNCK4yAY0jDgVFjHx4eSuh8P3VbAx5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Timezone information  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Timezone information  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Thu, Feb 20, 2014 at 4:31 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
It depends on how you are declaring the timestamp field. If you do not use with time zone then the input value is open to interpretation and is not  'anchored' to a point in time.

Example

My time zone is currently PST.
test=> create table timestamp_test(id int, ts timestamp, ts_z timestamp with time zone);
CREATE TABLE
test=> insert into timestamp_test values (1, now(), now());
INSERT 0 1
.....
If you know what time zone the value was inserted under you can get it back.
.
.
That assumes a lot, so the best thing is to use timestamp with time zone.

Thanks for trying this out on your setup. However looks like my requirement is different here.

Regards...

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

Предыдущее
От: Dev Kumkar
Дата:
Сообщение: Re: Timezone information
Следующее
От: Dev Kumkar
Дата:
Сообщение: Re: UTF-8 collation on Windows?