[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Bug in date_part() ?
From:       jose <jose () sferacarta ! com>
Date:       2000-03-30 12:41:44
[Download RAW message or body]

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:loidl@lrz.de
> 80333 Munich, Germany           http://www.lrz.de

[prev in list] [next in list] [prev in thread] [next in thread]