RE: date_part bug? - Mailing list pgsql-admin

From Trewern, Ben
Subject RE: date_part bug?
Date
Msg-id 996802F75C3CD411B424001083FA445B05955C@CET_PONXX_FP001
Whole thread Raw
In response to date_part bug?  (Salvador Mainé <salvamaine@yahoo.com>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: A crashing query
Next
From: Tom Lane
Date:
Subject: Re: pg_dump potential bug