Display unix timestamp in a date format in MySQL

Aug 30, 2009 1 min read #mysql

This post is more than 18 months old. Technology changes quickly, so some of this content may be out of date (but that's not always the case). Please verify any technical or programming information against the current release.

Every once in a while, I forget about the built in awesomeness of MySQL. Today, I was looking at a unix timestamp from PHP in one of the fields and was wondering what that date was. Derr, use from_unixtime function!

SELECT from_unixtime(dateField) FROM tableName;

sql

Go to all posts