Re: strange timezone problem

Nick Johnson <ctfdy(at)spatula(dot)net> writes:
> I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:

> select create_date from article_lead;
> create_date
> ---------------------------
> 2007-11-04 16:35:33.17+00
> 2007-11-04 04:35:36.09+00
> 2007-11-05 04:35:36.38+00
> 2007-11-05 16:35:36.67+00
> (4 rows)

> select create_date from article_lead where create_date >= '2007-11-03
> 17:00:00.0' and create_date <='2007-11-04 16:00:00.0';
> create_date
> ---------------------------
> 2007-11-04 04:35:36.09+00

> Shouldn't that second row have been in the results of the second query?

Huh? Those results look perfectly sane to me.

> set TimeZone='America/Los_Angeles';
> select create_date from article_lead;
> create_date
> ---------------------------
> 2007-11-04 08:35:33.17-08
> 2007-11-03 21:35:36.09-07 <-- why 07?
> 2007-11-04 20:35:36.38-08
> 2007-11-05 08:35:36.67-08

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

regards, tom lane