Impala - bug timestamp

AlinaGHERMAN — Fri, 16 Sep 2022 09:20:06 GMT

Hello,

By doing these 2 queries I get the same result (1412640000):

select unix_timestamp('2014-10-07 00:00:00.209','yyyy-MM-dd HH:mm:ss.SSS') as date_event from myTable;

select unix_timestamp('2014-10-07 00:00:00.100','yyyy-MM-dd HH:mm:ss.SSS') as date_event from myTable;

However, by doing I get 1412640001

select unix_timestamp('2014-10-07 00:00:01.100','yyyy-MM-dd HH:mm:ss.SSS') as date_event from myTable; the timestamp changes well;

I have the feeling that the seconds are not taken into account,

My Impalad version is 2.1.0-cdh5 (build e48c2b48c53ea9601b8f47a39373aa83ff7ca6e2)

Thank you!

Re: Impala - bug timestamp

UkrZilla — Fri, 23 Jan 2015 14:19:54 GMT

Hi, Alina

Seconds are taken into unix times, not miliseconds.

So,

select unix_timestamp('2014-10-07 00:00:00.999','yyyy-MM-dd HH:mm:ss.SSS') = unix_timestamp('2014-10-07 00:00:00.100','yyyy-MM-dd HH:mm:ss.SSS')

Result: True

You can check it here

FYI