*

Recent

Author Topic: dateadded on MySQL  (Read 3052 times)

WhaaaaaTha

  • Newbie
  • *
  • Posts: 33
  • Force: +0/-0
dateadded on MySQL
« on: June 18, 2009, 02:23:51 PM »
i've been looking through the database

and on dd_games > dateadded

on this colum all games have this weired numbers what does this mean?

one of the number in my DB is

1245151849

what does that mean because it doesn't really tell me the date i added the game Lol

kurt

  • Developer
  • Hero Member
  • ******
  • Posts: 634
  • Force: +16/-1
Re: dateadded on MySQL
« Reply #1 on: June 18, 2009, 03:08:29 PM »
That is a Unix time stamp. It means the number of seconds after a certain point in time, back in 1970 if I remember correctly, which I probably don't. The system, and PHP, know how to interpet it into something more readable and spit it out for human eyes, but it stores it in that format when not told to do so otherwise.

Moving this to the support forum as well ;)

WhaaaaaTha

  • Newbie
  • *
  • Posts: 33
  • Force: +0/-0
Re: dateadded on MySQL
« Reply #2 on: June 18, 2009, 06:45:39 PM »
ah cool lol didnt know that