Hi all, I don't know if there's any SQL guru's here, but I have a nice problem.

I need to return the following from a where clause.....

In Simple English = (records within date range from today's date - 3 months)

I can't use a "between" as the dates are not static and the data is needed to populate a report on the fly, I've googled, read x3 books now and it's driving me mental.

Any ideas?

select * from yourtable
where datediff(m, YourdateColumn, Getdate()) < 3

It really depends on what version of SQL and database server you have. e.g.

select * from myTable where theDate > sysdate -3; --will work on oracle (for 3 days)

select * from myTable where theDate > add_months(sysdate,-3); -- will work on oracle for months

Similar approach for sybase, but there you a dateadd function (months, -3) - can't remeber the exact syntax.

Oracle 9.2i had a look at this seems to work, might post the context up in a mo, thanks guys!

I saw the add_months, couldn't work out the context probably being dumb!!

select distinct count (*) from sample where Changed_on > add_months(sysdate,-3)

Cheeky! It will work