Salvador =?iso-8859-1?Q?Main=E9?= <salvamaine@yahoo.com> 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