Peter Eisentraut <[EMAIL PROTECTED]> writes:
> SELECT EXTRACT(QUARTER FROM INTERVAL '200 days') gives 1. Why is that?
Because interval_part does
case DTK_QUARTER:
result = (tm->tm_mon / 3) + 1;
break;
Not sure that changing this is a good
Tom Lane wrote:
> "Eugene M. Hutorny" <[EMAIL PROTECTED]> 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 EXT
, September 21, 2007 7:21 PM
Subject: Re: [BUGS] BUG #3624: EXTRACT(QUARTER FROM INTERVAL) always returns
1
"Eugene M. Hutorny" <[EMAIL PROTECTED]> writes:
> SQL statemet
> SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');
> Returns: 1
> Expected: 0
Why
"Eugene M. Hutorny" <[EMAIL PROTECTED]> 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
Am Freitag, 21. September 2007 schrieb Eugene M. Hutorny:
> SQL statemet
> SELECT EXTRACT(QUARTER FROM INTERVAL '1 day');
>
> Returns: 1
> Expected: 0
> Or: ERROR: interval units "quarter" not supported
An alternative behavior would be to return something like
ceil($argument / (360/4))
or
