presto

format_datetime(from_unixtime(1510284058),'yyyy-MM-dd HH:mm:ss')

hive:

select from_unixtime(1323308943123,'yyyy-MM-dd HH:mm:ss')