SQL delete statement where date is greater than 30 days

delete from {TABLE} where {DATE} < DATEADD(day, -30, GETDATE())

replace {TABLE} with the target table name

replace {DATE} with the date field.