Tobias
04-27-2007, 12:21 PM
In combination with PHP it is common practice to use a so called "Unix Timestamp" to specify dates and times. This timestamp is just a huge integer number representing the number of seconds since 01/01/1970 (I'm not going into the details of it's technical disadvantages here).
Now, in Subdreamer and it's plugins there are often columns (in the plugin tables) like "date_added", "date_created", "date_updated" or similar (of type INT). Their contents (either 0 or a integer value like "1177676171") is not "readable" unless you're a genius. :)
So in case a specific timestamp or vice versa it's humanly readable representation are needed, here's a link to a website which offers a simple "translation" of both (not taking into account any timezones):
http://www.4webhelp.net/us/timestamp.php
If googling for "unix timestamp conversion" there are lots of other sites out there, I just found this one pretty handy to have.
See also Wikipedia:
English:
http://en.wikipedia.org/wiki/Unix_Timestamp
German:
http://de.wikipedia.org/wiki/Unixzeit
Now, in Subdreamer and it's plugins there are often columns (in the plugin tables) like "date_added", "date_created", "date_updated" or similar (of type INT). Their contents (either 0 or a integer value like "1177676171") is not "readable" unless you're a genius. :)
So in case a specific timestamp or vice versa it's humanly readable representation are needed, here's a link to a website which offers a simple "translation" of both (not taking into account any timezones):
http://www.4webhelp.net/us/timestamp.php
If googling for "unix timestamp conversion" there are lots of other sites out there, I just found this one pretty handy to have.
See also Wikipedia:
English:
http://en.wikipedia.org/wiki/Unix_Timestamp
German:
http://de.wikipedia.org/wiki/Unixzeit