Re: strange timezone problem

Поиск
Список
Период
Сортировка
От Nick Johnson
Тема Re: strange timezone problem
Дата
Msg-id 20071107092324.Y46367@turing
обсуждение исходный текст
Ответ на Re: strange timezone problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, 7 Nov 2007, Tom Lane wrote:

> Nick Johnson <ctfdy@spatula.net> writes:
> > I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:

[snip]

> > Shouldn't that second row have been in the results of the second query?
>
> Huh?  Those results look perfectly sane to me.

Ah, you're right of course.  Just a complete mental lapse on my part (thus
the need of a 'sanity' check).

> That's correct ... as of last year, DST extends through the first Sunday
> in November in the USA.

Twice in one morning the database was cleverer than me.

   Nick


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

Предыдущее
От: andy
Дата:
Сообщение: Re: strange timezone problem
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Re: DB on a ramdisk (was Re: Temporary, In-memory Postgres DB?)