mysql change time format to human readble code example Example: mysql date format unix timestamp SELECT FROM_UNIXTIME(timestamp) FROM your_table;