It works fine for me ver 6.5.3.
Stefan Loidl ha scritto:
> Hi,
>
> I'm currently using postgres 6.4.2 on Sun Solaris.
> There seems to be a strange bug in the date_part() function.
> See below:
>
> accounting=> SELECT date_part('day','03-26-2000'::date);
> date_part
> ---------
> 25
> (1 row)
>
> Whereas it works with a cast to datetime:
>
> accounting=> SELECT date_part('day','03-26-2000'::datetime);
> date_part
> ---------
> 26
> (1 row)
>
> For other dates both versions have the same correct result.
>
> Can somebody check if this bug also occurs in 6.5.3 or 7.0beta?
>
> Greetings,
> Stefan
>
> --
> Stefan Loidl Phone: +49 89 289-28882
> Leibniz-Rechenzentrum Fax: +49 89 2809460
> Barer Str. 21 mailto:[EMAIL PROTECTED]
> 80333 Munich, Germany http://www.lrz.de
