Re: BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns 1 - Mailing list pgsql-bugs

Tom Lane wrote:
> "Eugene M. Hutorny" <eugene@ksf.kiev.ua> writes:
> > SQL statemet
> > SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');
> >
> > Returns: 1
> > Expected: 0
>
> Why would you expect that?  Quarters are numbered 1 through 4.
> And it doesn't "always return 1":
>
> regression=# SELECT EXTRACT(QUARTER FROM INTERVAL '3 months');
>  date_part
> -----------
>          2
> (1 row)

SELECT EXTRACT(QUARTER FROM INTERVAL '200 days') gives 1.  Why is that?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/