Re: Output of date_part('quarter', date) - Mailing list pgsql-bugs

> I tried to use function date_part('quarter', date) in query and I have
> got wrong results...

Yeesh! Don't know what I was thinking at the time, but it sure is wrong.
If you have PostgreSQL built from source, then you can fix this by
editing src/backend/utils/timestamp.c on or around line 2056. Change a
single line, just under the "case DTK_QUARTER:" from

  result = (tm->tm_mon / 4) + 1;

to

  result = ((tm->tm_mon - 1) / 3) + 1;

and you should start getting the right answer. Will be fixed in the next
release.

                       - Thomas