FROM_UNIXTIME(trans_date) AS 'Action_date'

##</code><code>##

 SELECT serial_num, trans_date , actor, type, trans_data, content FROM transtable