I have this query but I want to change the date to delete everything that is from more than 1 hour ago based on the server time (or if not possible by server time by post date). How do I do that?
DELETE FROM wp_posts
WHERE post_date < '2008-06-06 19:18:00'
AND post_status = 'publish'
See Question&Answers more detail:os