Re: Timestamp with Timezone

Поиск
Список
Период
Сортировка
От Norberto Meijome
Тема Re: Timestamp with Timezone
Дата
Msg-id 4383176D.60803@meijome.net
обсуждение исходный текст
Ответ на Timestamp with Timezone  (Matthew Terenzio <matt@jobsforge.com>)
Список pgsql-general
Matthew Terenzio wrote:

> reading the docs . . . let's see if I've got it.
>
> 1. Timestamp with timezone accepts a timestamp with the additional
> timezone, converts it and stores it as GMT
> 2. It returns the value as the timestamp converted to the timezone of
> the local machine?

that's what it says, that's what it seems to do :)
you may also want to read section 9.9.3 of the 8.1 pgsql docs on how to
return the given timestamp in another TZ.

cheers,
Beto

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

Предыдущее
От: CSN
Дата:
Сообщение: Re: not null error in trigger on unrelated column
Следующее
От: Chris Kratz
Дата:
Сообщение: Re: Rule appears not to fire on insert w/ "except"