Support Questions
Find answers, ask questions, and share your expertise

Unix timestamp is not working in hive for particular date

Highlighted

Unix timestamp is not working in hive for particular date

New Contributor

hive (prod_open_area)> select unix_timestamp('20180325010000', 'yyyyMMddHHmmss');
1521939600
hive (prod_open_area)> select unix_timestamp('20180325020000', 'yyyyMMddHHmmss');
1521939600