How do I find out which posts were made on a specific day?

[Gary King]

How do I find out which posts were made on a specific day?

[Andy Huang]

You'd need to search through the [tableprefix]post table's date stamp. I'm fairly sure that's saved in unix time, so you'd need to figure out the range for the date you're searching for.

[Gary King]

Okay, although I was hoping for a nice, web interface instead of phpMyAdmin's.

[Lats]

It's reasonably simple to make your own non-vB page, just need to know the query...

SELECT 
    postid, 
    username, 
    pagetext 
FROM 
    post
WHERE 
    dateline >= unix_timestamp( '2006-07-25 12:00:00' ) 
AND 
    dateline <= unix_timestamp( '2006-07-26 23:59:59' ) 
ORDER BY 
    postid