Select data that is older then 30 days

[3dhomejoe]

Hello, Im trying to select data that is older then 30 days in my data base, this code that I have selects the past 30 days not the data that is older then 30 days,

SELECT starttime FROM attacktype_table WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY);

 

Thanks

Joe

[xander85]

Try:

 

SELECT starttime FROM attacktype_table WHERE starttime < DATE_SUB(CURDATE(),INTERVAL 30 DAY);