Impala -to_timestamp()

58 views Asked by At

Impala to_timestamp() returns extra 1 hour

SELECT to_timestamp(01051984, ddMMyyyy) 

returns '1984-05-01 00:00:00'.

SELECT to_timestamp(01041984, ddMMyyyy)

returns '1984-04-01 01:00:00' in DBeaver and Aqua Data Studio and '1984-04-01 00:00:00' in Hue. Why?

0

There are 0 answers