//unixtime

SELECT uid, from_unixtime(name_field_where_unixtime) FROM referral

  sql.