select to_char(1593419589000 / (1000 * 60 * 60 * 24) +
to_date('1970-01-01 08:00:00', 'YYYY-MM-DD HH24:MI:SS'),
'YYYY-MM-DD') createTime
from dual
select to_char(1593419589000 / (1000 * 60 * 60 * 24) +
to_date('1970-01-01 08:00:00', 'YYYY-MM-DD HH24:MI:SS'),
'YYYY-MM-DD') createTime
from dual