Re: [BUGS] Bug in date_part()

[Tom Lane]

[EMAIL PROTECTED] 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