Re: Bug in date_part() - Mailing list pgsql-bugs

phil@Stimpy.netroedge.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