On Sat, Jul 12, 2003 at 09:00:19 +0200,
Erik Thiele <[EMAIL PROTECTED]> wrote:
> hi
>
> I am having problems with understanding of date/time/interval handling
> in postgresql and sql in general.
>
> a,b are TIMESTAMP WITHOUT TIME ZONE
> c is INTERVAL
>
> mathematics tell me:
>
> a-b = (a+c) -
hi
I am having problems with understanding of date/time/interval handling
in postgresql and sql in general.
a,b are TIMESTAMP WITHOUT TIME ZONE
c is INTERVAL
mathematics tell me:
a-b = (a+c) - (b+c)
is this also true in sql? if for example c is "1 year", then depending
on the value of a and b