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

Hive timestamp conversion error

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