Operating system:
FreeBSD 4.4-STABLE
PostgreSQL version:
postmaster (PostgreSQL) 7.1.3
psql input:
test=> SELECT timestamp 'infinity' - timestamp 'infinity';
psql output:
?column?
-
-2147483648 days --2147483648:-2147483648:0
I got the following problem in PostgreSQL 7.1.3.
When I need to get next day relative to another one,
I do the following query:
SELECT date(date ? + interval '1 day').
But on '2001-10-28', I get this:
test=> SELECT date(date '2001-10-28' + interval '1 day');
date
2001-10-28
(1
On Thu, Jan 31, 2002 at 11:44:53AM -0500, Tom Pfau wrote:
> try 'set timezone to ' replacing with your timezone
> before your query.
>
> template1=# set timezone to est;
> SET VARIABLE
> template1=# SELECT date(date '2001-10-28' + interval '1 day');
> date
>
> 2001-10-29
> (1 r
