1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Date system

Discussion in 'XenForo Questions and Support' started by Tyrone Chicken, Sep 22, 2013.

  1. Tyrone Chicken

    Tyrone Chicken New Member

    I need to grab upgrade dates from the db, could anyone explain the format for this? this is whats in the db 1387670400 and it is meant to be Dec 22, 2013.
  2. Jeremy

    Jeremy Well-Known Member

    Tyrone Chicken likes this.
  3. Rigel Kentaurus

    Rigel Kentaurus Well-Known Member

    You can use this page to convert it:

    Screen Shot 2013-09-22 at 11.50.40 AM.png

    In your database

    SELECT from_unixtime(post_date) FROM xf_post;
    will give you the formatted date

Share This Page