scriptygoddess

Well.. this took me a little while, and I'm somewhat embarrased to admit it…

I was writing a script to pull some data from several tables, and the date field looked something like this:
1031849565

Its a Unix Timestamp (representing the number of seconds from Jan, 1 1970 up to sometime in 2037), and luckily MySQL gives you a good way to convert them into readable dates. When you make a SQL query, just add this around the timestamp field:

FROM_UNIXTIME(yourtable.yourfield, '%d, %m, %Y')

So a sample query would look like:

SELECT FROM_UNIXTIME(yourtable.yourfield, '%d, %m, %Y') WHERE yourtable.index > 0;

The %d, %m etc. represent date & time format variables… a complete list can be found in the MySQL Documentation in section 6.3.4