Tom Lane wrote:
> "Eugene M. Hutorny" <eugene(at)ksf(dot)kiev(dot)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/