Thread: date_part bug?

Hello:

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

Is it a bug?

--
Salvador Mainé

Are you using Mandrake 7.x.  It seems to have some problems with rounding and dates because of its use of certain compiler settings.  If you are, try using the Postgres 7.0.3 RPMs from one of the ftp mirrors.  They seem to work correctly.

Regards

Ben

> -----Original Message-----
> From: Salvador Mainé [mailto:salvamaine@yahoo.com]
> Sent: 28 March 2001 11:51
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] date_part bug?
>
>
> Hello:
>
> 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
>
> Is it a bug?
>
> --
> Salvador Mainé
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>

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