Impala数据库常用时间操作
select from_unixtime(unix_timestamp('2022-05-18 19:41:22'),'yyyy-MM-dd HH:mm:ss')
select minutes_sub(from_unixtime(unix_timestamp('2022-05-18 19:41:22'),'yyyy-MM-dd HH:mm:ss'),1)
select minutes_sub(from_unixtime(unix_timestamp(now()),'yyyy-MM-dd HH:mm:ss'),1)
select regexp_replace(from_unixtime(unix_timestamp(minutes_sub(from_unixtime(unix_timestamp(now()),'yyyy-MM-dd HH:mm:ss'),1))),'-|:| ','')
select hours_sub(from_unixtime(unix_timestamp('2022-05-18 19:41:22'),'yyyy-MM-dd HH:mm:ss'),1)
select hours_sub(from_unixtime(unix_timestamp(now()),'yyyy-MM-dd HH:mm:ss'),1)
select regexp_replace(from_unixtime(unix_timestamp(hours_sub(from_unixtime(unix_timestamp(now()),'yyyy-MM-dd HH:mm:ss'),1))),'-|:| ','')
select days_sub(from_unixtime(unix_timestamp('2022-05-18 19:41:22'),'yyyy-MM-dd HH:mm:ss'),1)
select days_sub(from_unixtime(unix_timestamp(now()),'yyyy-MM-dd HH:mm:ss'),1)
select months_sub(from_unixtime(unix_timestamp('2022-05-18 19:41:22'),'yyyy-MM-dd HH:mm:ss'),1)
select months_sub(from_unixtime(unix_timestamp(now()),'yyyy-MM-dd HH:mm:ss'),1)