SQL Statement for look-up range of time by month

NaomiC · #1 (**permalink**) 09-29-03, 12:46

Hello!

I have been sucessful in finding a way to query using a specific date range but would LOVE to be able to find a way to query by a non date-specific time range.

For instance:

Selct all records that expire from today plus one month or expire today minus one month.

I will be forever in awe and extremely thankful of who ever can help!

Naomi

LKBrwn_DBA · #2 (**permalink**) 09-29-03, 18:34

In Oracle:

Code:


select * from MyTable
where exp_date between sysdate and add_months(sysdate,1);

Or

select * from MyTable
where exp_date between sysdate and add_months(sysdate,-1);

Or

select * from MyTable
where exp_date between add_months(sysdate,-1)
and add_months(sysdate,1);

absent · #3 (**permalink**) 10-01-03, 14:11

Hey there...

I think we have a similar problem... I'm trying to get SQL to return a query using user definable variables. sortta like something from a dropdown box.text to generate queries... But alas I can't find anything short of creating EACH and every query myself.

Is there a way to go around the short way?

Internet Services

Web Development

Digital Marketing

Consumer Tech