Re: date_part bug?

Salvador =?iso-8859-1?Q?Main=E9?=  writes:
> I'm using postgres 7.0.2. When I use date_part('day', date) sometimes I
> get wrong values. Ie: 
> and date_part('day', '1999-3-28')=27
> and date_part('day', '2000-3-26')=25

If those dates are daylight-savings transition days where you live,
then this is a known bug (date-to-timestamp conversion is off one hour
on such dates).  It's fixed for 7.1.

			regards, tom lane