ten digit mySQL date format

Discussion in 'MySQL' started by Joobz, Jul 18, 2007.

0
  1. #1
    how do I go about translating a date format that looks something like this:
    1184781645

    what is it called?

    Thanks
     
    Joobz, Jul 18, 2007 IP
  2. DavidAusman

    DavidAusman Peon

    Messages:
    399
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    it is a unix timestamp
    You can use PHP to translate it
    echo date("D, d-m-Y", 1184781645);
     
    DavidAusman, Jul 18, 2007 IP