Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output.

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: How to get timezone offset in timestamp with time zone AT TIME ZONE output.
Дата
Msg-id 87impio1tf.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: How to get timezone offset in timestamp with time zone AT TIMEZONE output.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: How to get timezone offset in timestamp with time zone AT TIMEZONE output.
Список pgsql-general
Дерево обсуждения 
>>>>> "Adrian" == Adrian Klaver <adrian.klaver@aklaver.com> writes:

 Adrian> This has come up before and the general suggestion has been to
 Adrian> have a column for a naive(timestamp w/o tz) timestamp and a
 Adrian> column for the timezone.

No, that's usually (not always) backwards, and in any event wouldn't
solve this particular issue.

-- 
Andrew (irc:RhodiumToad)

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: postgres 9.6: insert into select finishes only in pgadmin notpsql
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Autovacuum lock conflict