Skip to content

Adding Human Readable Date to MySQL Query

SELECT *, FROM_UNIXTIME( 't_stamp_column') AS date FROM 'tablename'

For formatting the date see MySQL's date functions information.

Popularity: 13% [?]

Posted in SQL, Snippets.

No comments

By damonp – 5/15/2007

0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.

« »