Adding Human Readable Date to MySQL Query

by damonp on May 15, 2007

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

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

Popularity: 1% [?]

Leave a Comment

Previous post:

Next post: