FROM_UNIXTIME(unix_timestamp), FROM_UNIXTIME(unix_timestamp,format) w 1 SELECT ro.*, FROM_UNIXTIME(ro.wstart,'%Y%m%d') FROM room_order ro