Re: timestamp <-> ctime conversion question...

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: timestamp <-> ctime conversion question...
Дата
Msg-id 20051213195511.GN5531@merkur.hilbert.loc
обсуждение исходный текст
Ответ на Re: timestamp <-> ctime conversion question...  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
On Tue, Dec 13, 2005 at 12:34:19PM -0700, Michael Fuhr wrote:

> > *Display* of timestamptz values at arbitrary time zones is
> > already possible using the "at time zone" syntax.
>
> But the result is a timestamp without time zone and thus doesn't
> display the target time zone.  In other words, you can display a
> timestamptz *at* another time zone but not *with* another time zone.
Ah, OK, there's a subtle difference, true.

However, if in my code I am able to say "at time zone ..." I
*already* know the time zone. Can't I then just *add* it to
the value I am getting back from the database ?

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: timestamp <-> ctime conversion question...
Следующее
От: David Rysdam
Дата:
Сообщение: "incomplete startup packet" on SGI