diff options
Diffstat (limited to 'src/backend/utils/adt/timestamp.c')
| -rw-r--r-- | src/backend/utils/adt/timestamp.c | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/backend/utils/adt/timestamp.c b/src/backend/utils/adt/timestamp.c index 11a75cc2bd5..dafc8ae5bed 100644 --- a/src/backend/utils/adt/timestamp.c +++ b/src/backend/utils/adt/timestamp.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/timestamp.c,v 1.102 2004/03/22 01:38:17 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/timestamp.c,v 1.103 2004/03/30 15:53:18 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -3261,7 +3261,11 @@ timestamp_part(PG_FUNCTION_ARGS) break; case DTK_YEAR: - result = tm->tm_year; + if (tm->tm_year > 0) + result = tm->tm_year; + else + /* there is no year 0, just 1 BC and 1 AD*/ + result = tm->tm_year - 1; break; case DTK_DECADE: |