Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Lats
    replied
    It's reasonably simple to make your own non-vB page, just need to know the query...
    Code:
    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

    Leave a comment:


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

    Leave a comment:


  • Andy Huang
    replied
    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.

    Leave a comment:


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

    How do I find out which posts were made on a specific day?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X