Use MySQL date functions DATE_FORMAT or FROM_UNIXTIME

SELECT DATE_FORMAT('1997-10-04 22:23:00', '%D %y %a %d %m %b %j');