> > If you take any other month than October, it is working fine. So
> > 09-01-2000 + 1 month => 10-01-2000.
> regression=# select ('10-01-2000'::timestamp + ('1 month')::timespan);
> ?column?
>
> 2000-10-31 23:00:00-05
> (1 row)
> Thomas, isn't the addition of '1
Moritz Gmelin <[EMAIL PROTECTED]> writes:
> If you take any other month than October, it is working fine. So
> 09-01-2000 + 1 month => 10-01-2000.
Hmm, I was expecting to find that fixed in current sources, but it's
still broken:
regression=# select ('10-01-2000'::timestamp + ('1 month')::timesp
Hi Folks !
I just found a bug in the postgresql time/date routines.
Try the following in the psql shell :
select ('10-01-2000'::date + ('1 month')::timespan)::date;
The result is going to be
10-31-2000
But it should be
11-01-2000
If you take any other month than October, it is working fine
