sql - How to convert "2019-11-02T20:18:00Z" to timestamp in HQL?

Question

I have datetime string "2019-11-02T20:18:00Z". How can I convert it into timestamp in Hive HQL?

Answer 1

try this:

select from_unixtime(unix_timestamp("2019-11-02T20:18:00Z", "yyyy-MM-dd'T'HH:mm:ss"))