Salvador =?iso-8859-1?Q?Main=E9?= <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
