Support Questions
Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Advanced Search

Unix timestamp is not working in hive for particular date

Highlighted

Unix timestamp is not working in hive for particular date

Labels:
gokulra
New Contributor

Created ‎06-01-2020 06:17 AM

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

Reply
161 Views
0 Kudos
Tags (2)
Don't have an account?
Register
Announcements
Product Announcements
[ANNOUNCE] New Cloudera JDBC 2.6.20 Driver for Apache Impala Released
Product Announcements
Transition to private repositories for CDH, HDP and HDF
Product Announcements
[ANNOUNCE] New Applied ML Research from Cloudera Fast Forward: Few-Shot Text Classification
Product Announcements
[ANNOUNCE] New JDBC 2.6.13 Driver for Apache Hive Released
Product Announcements
[ANNOUNCE] Refreshed Research from Cloudera Fast Forward: Semantic Image Search and Federated Learning
View More Announcements