select
 FROM_UNIXTIME('%Y:%M:%D'),
 FROM_UNIXTIME('%h:%i:%s'),
 other, fields, you want
... rest of query