Skip site navigation (1) Skip section navigation (2)

Interval+tz-tz gives unexpected result

From: "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
To: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Interval+tz-tz gives unexpected result
Date: 2002-11-11 14:26:34
Message-ID: E382B5D8EDE1D6118DBE0008C759BCD6116AAA@WCPEXCHANGE (view raw or flat)
Thread:
Lists: pgsql-bugs
dev=# select '0 sec'::interval+'2002/10/21 09:48'::timestamptz-'2002/10/21
09:30'::timestamptz;
 ?column?
----------
 -09:30
(1 row)

I would have expected '00:18'

dev=# select version();
                           version
--------------------------------------------------------------
 PostgreSQL 7.2.3 on i686-pc-cygwin, compiled by GCC 2.95.3-5
(1 row)

Thank you,
- Stuart

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-11-11 17:09:52
Subject: Re: Interval+tz-tz gives unexpected result
Previous:From: pgsql-bugsDate: 2002-11-11 10:44:15
Subject: Bug #813: postmaster not running

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group