diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-24 00:21:26 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-24 00:21:26 +0000 |
| commit | 47f14e7ddf4a1e139ca1a05e673be4f1d3c1dc06 (patch) | |
| tree | a0feee54cf4065f7faef3f0d346a10d89b7cc1d0 /src/backend/utils/adt/date.c | |
| parent | 2d9a001c9efafa777e7be7a773c681e4ddff685d (diff) | |
| download | postgresql-47f14e7ddf4a1e139ca1a05e673be4f1d3c1dc06.tar.gz postgresql-47f14e7ddf4a1e139ca1a05e673be4f1d3c1dc06.zip | |
Repair 7.3 breakage in timestamp-to-date conversion for dates before 2000.
Diffstat (limited to 'src/backend/utils/adt/date.c')
| -rw-r--r-- | src/backend/utils/adt/date.c | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/src/backend/utils/adt/date.c b/src/backend/utils/adt/date.c index ea1768be79d..fe7daaadbb5 100644 --- a/src/backend/utils/adt/date.c +++ b/src/backend/utils/adt/date.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.84 2003/07/17 00:55:37 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/adt/date.c,v 1.85 2003/07/24 00:21:26 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -348,17 +348,17 @@ timestamp_date(PG_FUNCTION_ARGS) { Timestamp timestamp = PG_GETARG_TIMESTAMP(0); DateADT result; + struct tm tt, + *tm = &tt; + double fsec; if (TIMESTAMP_NOT_FINITE(timestamp)) PG_RETURN_NULL(); -#ifdef HAVE_INT64_TIMESTAMP - /* Microseconds to days */ - result = (timestamp / INT64CONST(86400000000)); -#else - /* Seconds to days */ - result = (timestamp / 86400.0); -#endif + if (timestamp2tm(timestamp, NULL, tm, &fsec, NULL) != 0) + elog(ERROR, "Unable to convert timestamp to date"); + + result = date2j(tm->tm_year, tm->tm_mon, tm->tm_mday) - POSTGRES_EPOCH_JDATE; PG_RETURN_DATEADT(result); } |