|
8 | 8 | *
|
9 | 9 | *
|
10 | 10 | * IDENTIFICATION
|
11 |
| - * $Header: /cvsroot/pgsql/src/backend/utils/adt/timestamp.c,v 1.86 2003/07/17 00:55:37 tgl Exp $ |
| 11 | + * $Header: /cvsroot/pgsql/src/backend/utils/adt/timestamp.c,v 1.87 2003/07/26 15:17:36 momjian Exp $ |
12 | 12 | *
|
13 | 13 | *-------------------------------------------------------------------------
|
14 | 14 | */
|
@@ -2533,7 +2533,7 @@ timestamp_trunc(PG_FUNCTION_ARGS)
|
2533 | 2533 | caseDTK_YEAR:
|
2534 | 2534 | tm->tm_mon=1;
|
2535 | 2535 | caseDTK_QUARTER:
|
2536 |
| -tm->tm_mon= (3* (tm->tm_mon/4))+1; |
| 2536 | +tm->tm_mon= (3* ((tm->tm_mon-1) /3))+1; |
2537 | 2537 | caseDTK_MONTH:
|
2538 | 2538 | tm->tm_mday=1;
|
2539 | 2539 | caseDTK_DAY:
|
@@ -2626,7 +2626,7 @@ timestamptz_trunc(PG_FUNCTION_ARGS)
|
2626 | 2626 | caseDTK_YEAR:
|
2627 | 2627 | tm->tm_mon=1;
|
2628 | 2628 | caseDTK_QUARTER:
|
2629 |
| -tm->tm_mon= (3* (tm->tm_mon/4))+1; |
| 2629 | +tm->tm_mon= (3* ((tm->tm_mon-1) /3))+1; |
2630 | 2630 | caseDTK_MONTH:
|
2631 | 2631 | tm->tm_mday=1;
|
2632 | 2632 | caseDTK_DAY:
|
@@ -2719,7 +2719,7 @@ interval_trunc(PG_FUNCTION_ARGS)
|
2719 | 2719 | caseDTK_YEAR:
|
2720 | 2720 | tm->tm_mon=0;
|
2721 | 2721 | caseDTK_QUARTER:
|
2722 |
| -tm->tm_mon= (3* (tm->tm_mon /4)); |
| 2722 | +tm->tm_mon= (3* (tm->tm_mon /3)); |
2723 | 2723 | caseDTK_MONTH:
|
2724 | 2724 | tm->tm_mday=0;
|
2725 | 2725 | caseDTK_DAY:
|
@@ -3297,7 +3297,7 @@ interval_part(PG_FUNCTION_ARGS)
|
3297 | 3297 | break;
|
3298 | 3298 |
|
3299 | 3299 | caseDTK_QUARTER:
|
3300 |
| -result= (tm->tm_mon /4)+1; |
| 3300 | +result= (tm->tm_mon /3)+1; |
3301 | 3301 | break;
|
3302 | 3302 |
|
3303 | 3303 | caseDTK_YEAR:
|
|