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.

Hive timestamp conversion error

Highlighted

Hive timestamp conversion error

New Contributor

select to_utc_timestamp('1984-04-01 00:00:00.0','UTC');

1984-04-01 01:00:00.0


select to_utc_timestamp('1984-04-01 01:00:00.0','UTC');

1984-04-01 01:00:00.0


select to_utc_timestamp('1984-04-01 02:00:00.0','UTC');

1984-04-01 02:00:00.0


select to_utc_timestamp('1992-03-29 00:00:00.0','UTC');

1992-03-29 01:00:00.0


select to_utc_timestamp('1983-04-01 00:00:00.0','UTC');

1983-04-01 01:00:00.0


'1984-04-01 00:00:00.0' = 1984-04-01 01:00:00.0 +1h

'1984-04-01 01:00:00.0' = 1984-04-01 01:00:00.0

'1984-04-01 02:00:00.0' = 1984-04-01 02:00:00.0

'1992-03-29 00:00:00.0' = 1992-03-29 01:00:00.0 +1h

'1983-04-01 00:00:00.0' = 1983-04-01 01:00:00.0 +1h