Time difference changed in 7.2
От | Alfred Tuinman |
---|---|
Тема | Time difference changed in 7.2 |
Дата | |
Msg-id | 5.1.0.14.0.20020219200630.00a058d0@192.168.0.12 обсуждение исходный текст |
Список | pgsql-general |
Hi, I have exactly the same problem but haven't seen a reply with a solution as yet. Anybody got any ideas? Thanks, Alfred Tuinman From: Gurunandan R. Bhat <grbhat@exocore.com> To: pgsql-general@postgresql.org Subject: [GENERAL] Time difference changed in 7.2 Date: 18 Feb 2002 21:59:08 +0530 Hi, The difference between two times (interval) seems to have undergone a change from 7.1 to 7.2. For example '1:00'::time - '23:00'::time = @ 2 hours in 7.1 and, '1:00'::time - '23:00'::time = @ 22 hours ago in 7.2. I assume there must be some sound reason for this change, but I have used time differences at loads of places in my considerably large application and the whole thing goes (not surprisingly) completely haywire. Is there some way I can revert to the old behaviour? Downgrading my postgres version is not a choice :). IAC, since '23:00'::time + '1:00'::interval = '1:00'::time, --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 08/02/2002
В списке pgsql-general по дате отправления: