date difference

Hi,

I have a date stored in a database which I want to use against the system date and only display those records in the database which are older than 6 months old.

Or would it be easier to allow the select statement to do this filtering. What would the where clause look like?

Any ideas would be very helpful.

regards

peter

Yes do it in the WHERE clause. It might be as easy as:

select *
from mytable
where pubDate > ( trunc( sysdate ) - 90 )

should get anything with a pubDate in the last 90 days (in an Oracle database). But each database is different so you'll have to dig around.

if it's Access, then you could do this

Where someDate BETWEEN DateAdd('m', -6, date()) AND date()

I'm doing it MS Sql.

Really just need the where clause.

Thanks for all your help. Great site

I'd ask in the MySQL forum.