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

Problem with interval

From: Bruno Prévost <bp(at)interaction(dot)ws>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem with interval
Date: 2004-10-06 20:26:06
Message-ID: 039801c4abe2$b5715ac0$5d00a8c0@BRUNO2500 (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

I'm using postgres version 7.4.5 and had a problem with interval

Here is my query :
select '2004/10/31'::timestamptz + '1 day'::interval;

Here is the answer :
10/31/2004 11:00:00 PM

Is it a bug or I do something wrong?
I tested my query on 3 server and have always the same answer.



pgsql-bugs by date

Next:From: Michael FuhrDate: 2004-10-06 21:47:55
Subject: Re: Problem with interval
Previous:From: Bruce MomjianDate: 2004-10-06 17:23:29
Subject: Re: pg_dumpall bug in PG 8.0b3 Win32 port

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