Pulling row that are at least 30 days old

[dadamssg87]

I have a "created" column in my table that uses CURRENT_TIMESTAMP. Can somebody help me write a query that pulls rows that are at least 30 days old?

<?php

$query = "SELECT * FROM Accounts where DateDiff(day,date(created),curdate()) > 30";
?>

 

I get this error with the above. #1582 - Incorrect parameter count in the call to native function 'DateDiff'

[Dazman2011]

I tend to use something like

WHERE date_field_to_test < DATE_SUB( NOW() , INTERVAL 30 DAY)