Just looks like to me that a non-qualified addition of one to a date data
type increments by one day and a non-qualified interval increments by seconds
(it's easier to strip off all the other junk in the query and just look at
what your date calculation is returning):
steve=# select '2002-12-06'::date + 1;
?column?
------------
2002-12-07
steve=# select '2002-12-06'::date + 1::interval;
?column?
------------------------
2002-12-06 00:00:01-08
steve=# select '2002-12-06'::date + '1 day'::interval;
?column?
------------------------
2002-12-07 00:00:00-08
Cheers,
Steve
On Friday 06 December 2002 4:32 pm, Laurette Cisneros wrote:
> 2002-12-06'::date + 1