Convert from unix time stamp to date time format

FROM_UNIXTIME(Table field name, ‘%Y-%m-%d’)

This funtion  convert unix time stamp to date time format.

for example :

FROM_UNIXTIME(Created, ‘%Y-%m-%d’)

Advertisements