Re: Computing Date Differences

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sun, 17 Mar 2002 03:43:13 GMT
Message-ID: <lhUk8.57932$uA5.59274@rwcrnsc51.ops.asp.att.net>

select date from person where
date > (select date+7 from person where name='John Smith' )

is that what you mean

"Lekeas GK" <cj571_at_soi.city.ac.uk> wrote in message news:Pine.GSO.4.02A.10203170323430.19034-100000_at_vega.soi.city.ac.uk...
> Hi All,
>
> I am having the following problem: I need to answer a question which goes
> like find all the surnames of people who were born a week later than john
> smith. I have tried something like:
>
> select date from person where
> date > (select date from person where name='John Smith' + 7 but it didn't
> work (The error message was SQL command not properly terminated).
>
> Could anyone please help me with that?
>
> I look forward to hearing from you soon.
>
> Thanks in advance.
>
> George
>
Received on Sat Mar 16 2002 - 21:43:13 CST