How to convert a timestamp (with a dot between a second and a millisecond) today (yyyyMMdd) to Hive?

Question

I want to convert the timestamp, 1490198341.705 for example, for today 20170323 and at 11 o’clock (GMT + 8: 00). Are there any features to solve this problem?

Answer 1

Try the following:

 select date_format(from_utc_timestamp(1490198341.705,'GMT+8:00'),'yyyyMMdd HH:mm:ss');