diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-07-20 16:42:32 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-07-20 16:42:32 +0000 |
| commit | db05f4a7eb6c80c67c25ca9d28be825b99ed3553 (patch) | |
| tree | dee67dee9058a0243609c838c6be521143d23f3b /src/backend/utils/adt/date.c | |
| parent | 826604f9e61c233c4229a3eb4d1ee3945691ee1b (diff) | |
| download | postgresql-db05f4a7eb6c80c67c25ca9d28be825b99ed3553.tar.gz postgresql-db05f4a7eb6c80c67c25ca9d28be825b99ed3553.zip | |
Add 'day' field to INTERVAL so 1 day interval can be distinguished from
24 hours. This is very helpful for daylight savings time:
select '2005-05-03 00:00:00 EST'::timestamp with time zone + '24 hours';
?column?
----------------------
2005-05-04 01:00:00-04
select '2005-05-03 00:00:00 EST'::timestamp with time zone + '1 day';
?column?
----------------------
2005-05-04 01:00:00-04
Michael Glaesemann
Diffstat (limited to 'src/backend/utils/adt/date.c')
| -rw-r--r-- | src/backend/utils/adt/date.c | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/backend/utils/adt/date.c b/src/backend/utils/adt/date.c index 85c2f86b248..b416db54385 100644 --- a/src/backend/utils/adt/date.c +++ b/src/backend/utils/adt/date.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/date.c,v 1.112 2005/07/12 15:17:44 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/date.c,v 1.113 2005/07/20 16:42:30 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -1423,6 +1423,7 @@ time_interval(PG_FUNCTION_ARGS) result = (Interval *) palloc(sizeof(Interval)); result->time = time; + result->day = 0; result->month = 0; PG_RETURN_INTERVAL_P(result); @@ -1477,8 +1478,9 @@ time_mi_time(PG_FUNCTION_ARGS) result = (Interval *) palloc(sizeof(Interval)); - result->time = (time1 - time2); result->month = 0; + result->day = 0; + result->time = time1 - time2; PG_RETURN_INTERVAL_P(result); } |