1. --HQL ms
    2. from_unixtime(CAST(obtained_ms/1000 AS BIGINT), 'yyyy-MM-dd HH:mm:ss')
    4. --SQL ms
    5. from_unixtime(time_in_ms / 1000)
    7. --SQL date
    8. date(from_unixtime(time_in_ms / 1000)) as dt