If I change it to current_date it doesn't return anything. I'm starting to get lost here, perhaps I am storing the date wrong?
It's set to just use time() unless a date is specified in which case it uses strtotime() to convert it.
So for instance I'm using this now in myAdmin
WHERE post_status = 'auto-draft'
AND UNIX_TIMESTAMP( DATE_SUB( NOW( ) , INTERVAL 1
MINUTE ) ) > date_created
This returns 29 rows, the earliest date being:
Wed, 02 Nov 2011 14:42:43 GMT
And the latest:
Wed, 02 Nov 2011 15:26:12 GMT
But doesn't return the next post along:
Wed, 02 Nov 2011 15:26:13 GMT
That's only .1 second older and the latest post I created was made only 20 minutes ago, so they should all be showing up under there. Is this an issue with using NOW()?
I assume nothing is showing up under current_date because it is using the date not the immediate time?