View Single Post
06-10-2009, 01:53 AM
La Vida es Sueño
Join Date: Sep 2007
That is the Unix timestamp of the
time and date. It is the amount of seconds since midnight of January the 1st, 1970. It is pretty standard in the programming world because it takes everything into consideration, leap years included.
It contains all the data you require for the time and date, with a precision of a second.
If we're to convert that Unix timestamp you supplied then we would convert it using the
function, in the specified format. All the available formats are described on
its PHP.net page
Just from that data you supplied I can tell you that is 02:36:48 using the following line of code:
Unfortunately, I am not sure on the date because I've not requested that information, but the timestamp still contains that data.
To see the time and the date for that timestamp I can do the following to tell you what it is:
I now know that timestamp is the 10th of June, 2009 at 02:36:48. This is also timezone specific because to me there are still the same amount of seconds since 1970, as there are to you, because the changes in the timezone are relative.
At this very second the timestamp is 1244598646.
we can see that is the equivalent to a very precise 39.4397936 years.
Sorry, I probably misread your post as I am ever so tired. In MySQL you can do the following:
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.
The Following 2 Users Say Thank You to Wildhoney For This Useful Post:
View Public Profile
Send a private message to Wildhoney
Visit Wildhoney's homepage!
Find More Posts by Wildhoney