That is the Unix timestamp of the current 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 date 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:
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. In Google we can see that is the equivalent to a very precise 39.4397936 years.
Edit: 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: