diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-03-30 15:53:18 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-03-30 15:53:18 +0000 |
| commit | fd071bd478f489c81208029265e1fef954a9b5fa (patch) | |
| tree | a93be11ef80a963d363e7e158bb28078ad5414e5 /src/backend/utils/adt/timestamp.c | |
| parent | f2c064afcbfad4999d7e9ccb644a8aa99463a1ac (diff) | |
| download | postgresql-fd071bd478f489c81208029265e1fef954a9b5fa.tar.gz postgresql-fd071bd478f489c81208029265e1fef954a9b5fa.zip | |
Fix to_char for 1 BC. Previously it returned 1 AD.
Fix to_char(year) for BC dates. Previously it returned one less than
the current year.
Add documentation mentioning that there is no 0 AD.
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: |