[HOW-TO] 1 line mySQL QUERY to delete users inactive 6 months with 0 posts

[pavemen]

you can use UNIX_TIMESTAMP() to convert the date for you, assuming you are using MySQL or another RDBMS that supports that function.

DELETE FROM mybb_users where postnum = '0' and lastvisit < UNIX_TIMESTAMP('2010-10-30 00:00:00')