Impala函数支持的时间格式:
select add_months('2020-05-20', 2); 2020-07-20 00:00:00
select adddate('2020-02-20', 2); 2020-02-22 00:00:00
select current_timestamp(); 2020-08-06 16:46:36.403408000
SELECT date_add('2020-04-05', 10); 2020-04-15 00:00:00
SELECT date_part('year', '2020-04-02'); 2020
SELECT date_sub('2020-05-20', 9); 2020-05-11 00:00:00
select datediff('1997-08-15', '2020-08-06'); -8392
select from_timestamp('2020-08-06', 'yyyyMMdd'); / select from_timestamp('2020-08-06 10:10:10', 'yyyyMMdd'); 20200806
SELECT unix_timestamp('2020-05-20'); 1589932800
select unix_timestamp('2020-09-08 10:10:56'); 1599559856