phil(at)Stimpy(dot)netroedge(dot)com writes:
> edge=# select date_part('dow','4/1/2001'::date)::int4;
> ?column?
> ----------
> 6
> (1 row)
Seems to be fixed in current sources:
regression=# select date_part('dow','4/1/2001'::date)::int4;
?column?
----------
0
(1 row)
I think this is a side-effect of the known 7.0 bug in date-to-timestamp
conversion on DST transition days. Check out
select '4/1/2001'::date::timestamp;
regards, tom lane