Hello!
On Thu, 17 Dec 1998, Tim Williams wrote:
> When I run the following set of statements in postgres v6.4 (built on
> Debian Linux):
>
> create table tmp (v1 date, v2 datetime);
> insert into tmp values ('06-01-1999', '06-01-1999');
> select date_part('month', v1) as m1, date_part('month', v2) as m2 from
> tmp;
>
> I see the following results:
>
> m1|m2
> --+--
> 5| 6
> (1 row)
>
> Why is date_part giving different results for date and date_time? Why
> is it wrong for 'date'? Anybody seen this before?
I tried this and it works pretty good for me on Solaris.
It looks like an error in postgres on glibc2-based linux platform. It is
discussing now on pgsql-hackers list. The solution is not ready yet. I am
working on this with a good deal of help from other people...
Oleg.
----
Oleg Broytmann http://members.tripod.com/~phd2/ phd2@earthling.net
Programmers don't die, they just GOSUB without RETURN.