diff options
Diffstat (limited to 'src/backend/utils/adt/selfuncs.c')
| -rw-r--r-- | src/backend/utils/adt/selfuncs.c | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/src/backend/utils/adt/selfuncs.c b/src/backend/utils/adt/selfuncs.c index 85dd4196c61..33726945a3e 100644 --- a/src/backend/utils/adt/selfuncs.c +++ b/src/backend/utils/adt/selfuncs.c @@ -15,7 +15,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/selfuncs.c,v 1.184 2005/07/12 16:04:57 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/selfuncs.c,v 1.185 2005/07/20 16:42:30 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -2784,10 +2784,11 @@ convert_timevalue_to_scalar(Datum value, Oid typid) * too accurate, but plenty good enough for our purposes. */ #ifdef HAVE_INT64_TIMESTAMP - return (interval->time + (interval->month * ((365.25 / 12.0) * 86400000000.0))); + return interval->time + interval->day * (double)USECS_PER_DAY + + interval->month * ((365.25 / 12.0) * USECS_PER_DAY); #else - return interval->time + - interval ->month * (365.25 / 12.0 * 24.0 * 60.0 * 60.0); + return interval->time + interval->day * SECS_PER_DAY + + interval->month * ((365.25 / 12.0) * (double)SECS_PER_DAY); #endif } case RELTIMEOID: |