Re: [SQL] time date interval...

2003-07-12 Thread Bruno Wolff III
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) -

[SQL] time date interval...

2003-07-12 Thread Erik Thiele
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