RE: date_part bug?

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(at)yahoo(dot)com]
> Sent: 28 March 2001 11:51
> To: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org)
>