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

Interpreting Date from DB

Discussion in 'XenForo Development Discussions' started by MOZ, Aug 10, 2012.

  1. MOZ

    MOZ Well-Known Member

    How do I read the date from the DB. Not technically but how do I interpret it.

    It is a 10 digit integer. Something like:1344545345
     
  2. chrisj

    chrisj Active Member

    <xen:datetime time="{$your_variable}" />
    Thats for outputting into html and gives you A moment ago, 11 minutes ago, etc.
     
  3. CyclingTribe

    CyclingTribe Well-Known Member

  4. Luke F

    Luke F Well-Known Member

    select FROM_UNIXTIME(1344545345)
     
  5. MOZ

    MOZ Well-Known Member

    Thanks. Got it.
     

Share This Page