--HQL ms
from_unixtime(CAST(obtained_ms/1000 AS BIGINT), 'yyyy-MM-dd HH:mm:ss')

--SQL ms
from_unixtime(time_in_ms / 1000)

--SQL date
date(from_unixtime(time_in_ms / 1000)) as dt