My Blog

contains PHP and other web related content. (Sometimes there are some off topic things - don't freak out!)

Display unix timestamp in a date format in MySQL

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!

1

SELECT from_unixtime(dateField) FROM tableName;

Tags:

«
»

This entry was posted on Sunday, August 30th, 2009 at 2:03 pm and is filed under mysql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

  • twitter loader

Follow me on twitter: @aaronsaray

The views on this website are my own and do not reflect the opinions of my employer or clients.
Creative Commons License Home | Open Source | Book | Music | Art | Bio | Resume | Contact
My Baby