Tuesday, May 15, 2007

Adding Human Readable Date to MySQL Query

by damonp on May 15, 2007

in Snippets,SQL

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

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

Popularity: 1%

{ 0 comments }