【Impala】根据当前日期取去年、今年、上月、日期差
--去年
SUBSTR(REGEXP_REPLACE(CAST(YEARS_ADD(NOW(), 1) AS STRING) ,'-',''),1,4) AS LAST_YEAR
SUBSTR(REGEXP_REPLACE(CAST(NOW() AS STRING),'-',''),1,4) AS THIS YEAR
--日期差
DATEDIFF(FROM_UNIXTIME(UNIX_TIMESTAMP(END_DATE,'YYYYMMDD'),'YYYY-MM-DD'),--将end_date字段转为.
原创
2021-09-24 15:48:02 ·
3514 阅读 ·
1 评论