how to display records that are less then 30 days old

[elyasn]

i am trying to  display records that are less then 30 days old.

 

i used DATE_SUB(CURDATE(),INTERVAL 30 DAY)  but poroblem with  date_ sub is it will show the futre dates too.

 

i want to be able to only dispaly dates for the past 30 days.

 

is there a way i can achive this with timstamp?

 

 

 

[beebum]

...WHERE date BETWEEN (DATE_DUB(CURDATE(), INTERVAL 30 DAY)) AND CURDATE();