Selecting records before timestamp period

_sh

Guys,

When writing rows to a DB, I'm using the MySQL built in TimeStamp column type - now I want to select all rows that are no more than 30 days old, what is the syntax to do something like this?

I've tried this and it finds no results...

"SELECT AdvertTitle, AdvertDateAdded FROM tbl_marketplace_adverts WHERE AdvertDateAdded > now()-30"

Am I being silly?

sneakyimp

this might work:

SELECT AdvertTitle, AdvertDateAdded FROM tbl_marketplace_adverts WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) < AdvertDateAdded;

It's the example given here.

_sh

sneakyimp;10907131 wrote:
this might work:
SELECT AdvertTitle, AdvertDateAdded FROM tbl_marketplace_adverts WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) < AdvertDateAdded;
It's the example given here.

Many thanks! Will give this a go!