Convert timestamp to date in MYSQL

Comments Sep 9, 2011 | MySQL

Home \ Convert timestamp to date in MYSQL

SELECT DATE(FROM_UNIXTIME(`date_add`)) AS dateAdd FROM TABLE

Tags: convert date, date, timestamp