Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unix timestamp is not working in hive for particular date

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

Don't have an account?
Coming from Hortonworks? Activate your account here