Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Computing Date Differences
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
![]() |
![]() |