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)
>