Try this please:
from integer: SELECT FROM_UNIXTIME(timestamp_column / 1000) AS converted_date FROM your_table;
from string: SELECT string_timestamp, TO_TIMESTAMP(string_timestamp, 'yyyy-MM-dd HH:mm:ss') AS timestamp_with_time FROM your_table;