diff options
author | Thomas G. Lockhart <lockhart@fourpalms.org> | 2000-11-11 19:56:43 +0000 |
---|---|---|
committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 2000-11-11 19:56:43 +0000 |
commit | d74c52c357792d591fa56d1fa92979fb715fbb60 (patch) | |
tree | f4de77f3e2ab15d487c5696f47a5a7130af2ebf6 | |
parent | a669bd74eec487202c08093c7dfc6b245a43abb7 (diff) | |
download | postgresql-d74c52c357792d591fa56d1fa92979fb715fbb60.tar.gz postgresql-d74c52c357792d591fa56d1fa92979fb715fbb60.zip |
Allow more timezone-like interpretation of INTERVALs.
-rw-r--r-- | src/test/regress/expected/interval.out | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/src/test/regress/expected/interval.out b/src/test/regress/expected/interval.out index a8ea6c24d7d..d76c922a141 100644 --- a/src/test/regress/expected/interval.out +++ b/src/test/regress/expected/interval.out @@ -3,44 +3,44 @@ -- SET DATESTYLE = DEFAULT; -- check acceptance of "time zone style" -SELECT INTERVAL '01:00'; - ?column? +SELECT INTERVAL '01:00' AS "One hour"; + One hour ---------- +01:00 (1 row) -SELECT INTERVAL '+02:00'; - ?column? ----------- +SELECT INTERVAL '+02:00' AS "Two hours"; + Two hours +----------- +02:00 (1 row) -SELECT INTERVAL '-08:00'; - ?column? ----------- +SELECT INTERVAL '-08:00' AS "Eight hours"; + Eight hours +------------- -08:00 (1 row) -SELECT INTERVAL '-05'; - ?column? ------------ - -00:00:05 +SELECT INTERVAL '-05' AS "Five hours"; + Five hours +------------ + -05:00 (1 row) -SELECT INTERVAL '-1 +02:03'; - ?column? ----------- +SELECT INTERVAL '-1 +02:03' AS "22 hours ago..."; + 22 hours ago... +----------------- -21:57 (1 row) -SELECT INTERVAL '-1 days +02:03'; - ?column? ----------- +SELECT INTERVAL '-1 days +02:03' AS "22 hours ago..."; + 22 hours ago... +----------------- -21:57 (1 row) -SELECT INTERVAL '10 years -11 month -12 days +13:14'; - ?column? +SELECT INTERVAL '10 years -11 month -12 days +13:14' AS "9 years..."; + 9 years... -------------------------- 9 years 1 mon -11 -10:46 (1 row) |