OraFAQ Forum: SQL & PL/SQL » Less than filter

Home » SQL & PL/SQL » SQL & PL/SQL » Less than filter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Less than filter [message #2915]

Wed, 21 August 2002 05:55

MathewMcloughlin
Messages: 3
Registered: August 2002

Junior Member

I have a table which has two coloums date_start and date_finish and i'm wanting to filter the table down to the rows, in which the differnce between the dates is less than x days, x being a variable entered into a textbox. Apparently you cant do this by QBE because it cant handle greater than. I've tried using the database filter but this doesn't seem to accept date variables or any other variables. Any ideas would be great
Thanks

Report message to a moderator

Re: Less than filter [message #2917 is a reply to message #2915]

Wed, 21 August 2002 08:53

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select *
  from t
 where (date_finish - date_start) < :no_of_days;

Report message to a moderator

Previous Topic:	problem with PL/SQL COMMIT
Next Topic:	Reverse some characters in a string

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 21:00:41 CDT 2024