No announcement yet.

Date format?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Date format?

    Had a fellow admin ask if it were possible to find out who posted the most between 2 dates on his board, after the fact. I had the query figured out, but the date format stored with the post makes little sense to me.
    This number: 1117636429 was displayed as June 1 at 10:54 AM.

    Can anyone tell me how this number is arrived at, or where to look (regular forum post dates) for the bit that converts the "real" time into this integer?

  • #2
    That is a Unix timestamp. You can use this online tool to convert dates and times to Unix Timestamps:

    Just remember to enter in the GMT values for the date and not the date and time in your specific timezone.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      That's perfect. Thanks Steve!


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