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

  • 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?

  • #2
    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.
    Best Regards,
    Andy Huang

    Comment


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

      Comment


      • #4
        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
        Lats...

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X