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
