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/test | |
| parent | 826604f9e61c233c4229a3eb4d1ee3945691ee1b (diff) | |
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/test')
| -rw-r--r-- | src/test/regress/expected/interval.out | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/test/regress/expected/interval.out b/src/test/regress/expected/interval.out index daa6348785a..7480e7f2e55 100644 --- a/src/test/regress/expected/interval.out +++ b/src/test/regress/expected/interval.out @@ -28,21 +28,21 @@ SELECT INTERVAL '-05' AS "Five hours"; (1 row) SELECT INTERVAL '-1 +02:03' AS "22 hours ago..."; - 22 hours ago... ------------------ - -21:57:00 + 22 hours ago... +------------------- + -1 days +02:03:00 (1 row) SELECT INTERVAL '-1 days +02:03' AS "22 hours ago..."; - 22 hours ago... ------------------ - -21:57:00 + 22 hours ago... +------------------- + -1 days +02:03:00 (1 row) SELECT INTERVAL '10 years -11 month -12 days +13:14' AS "9 years..."; 9 years... ---------------------------------- - 9 years 1 mon -11 days -10:46:00 + 9 years 1 mon -12 days +13:14:00 (1 row) CREATE TABLE INTERVAL_TBL (f1 interval); |