diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-07-21 03:56:25 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-07-21 03:56:25 +0000 |
| commit | a536b2dd80f29464b0461e3980043ec4a822e820 (patch) | |
| tree | d474f168cd9ac2ac3a1b8a8647683f024e1dfe93 /src/backend/utils/adt/selfuncs.c | |
| parent | dc73819f2ef459696502877e89e46f41406c8d6b (diff) | |
| download | postgresql-a536b2dd80f29464b0461e3980043ec4a822e820.tar.gz postgresql-a536b2dd80f29464b0461e3980043ec4a822e820.zip | |
Add time/date macros for code clarity:
#define DAYS_PER_YEAR 365.25
#define MONTHS_PER_YEAR 12
#define DAYS_PER_MONTH 30
#define HOURS_PER_DAY 24
Diffstat (limited to 'src/backend/utils/adt/selfuncs.c')
| -rw-r--r-- | src/backend/utils/adt/selfuncs.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/utils/adt/selfuncs.c b/src/backend/utils/adt/selfuncs.c index 33726945a3e..3a22b8f72f1 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.185 2005/07/20 16:42:30 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/selfuncs.c,v 1.186 2005/07/21 03:56:18 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -2785,10 +2785,10 @@ convert_timevalue_to_scalar(Datum value, Oid typid) */ #ifdef HAVE_INT64_TIMESTAMP return interval->time + interval->day * (double)USECS_PER_DAY + - interval->month * ((365.25 / 12.0) * USECS_PER_DAY); + interval->month * ((DAYS_PER_YEAR / (double)MONTHS_PER_YEAR) * USECS_PER_DAY); #else return interval->time + interval->day * SECS_PER_DAY + - interval->month * ((365.25 / 12.0) * (double)SECS_PER_DAY); + interval->month * ((DAYS_PER_YEAR / (double)MONTHS_PER_YEAR) * (double)SECS_PER_DAY); #endif } case RELTIMEOID: |