> 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
