–获取今天
REPLACE(CAST((TO_DATE(CURRENT_TIMESTAMP)) AS VARCHAR(10)),’-’,’’) AS DATE
–获取这个月
LEFT(REPLACE(CAST((TO_DATE(CURRENT_TIMESTAMP)) AS VARCHAR(10)),’-’,’’),6) month
–获取上个月最后一天
SELECT LAST_DAY(ADD_MONTHS_LAST(TO_DATE (CURRENT_DATE, ‘YYYY-MM-DD’), -1)) “add months last”
YEAR (TO_DATE (CURRENT_DATE, ‘YYYY-MM-DD’)) “年度”
TO_CHAR(add_days(CURRENT_DATE ,-1),‘YYYYMMDD’) --昨天
TO_CHAR(add_months(CURRENT_DATE ,-1),‘YYYYMM’) --上个月 202202
TO_CHAR(CURRENT_DATE ,‘YYYYMM’) --月度
LAST_DAY(CURRENT_DATE)
select
REPLACE(CAST((TO_DATE(CURRENT_TIMESTAMP)) AS VARCHAR(10)),’-’,’’) AS DATE – 麻烦写法
,TO_CHAR(CURRENT_DATE,‘YYYYMMDD’) “今天”
,TO_CHAR(add_days(CURRENT_DATE ,-1),‘YYYYMMDD’) “昨天”
,to_char(concat(TO_CHAR(CURRENT_DATE,‘YYYY’),‘0101’)) “年初”
,LAST_DAY(ADD_MONTHS_LAST(TO_DATE (CURRENT_DATE, ‘YYYY-MM-DD’), -1)) “上月最后一天”
,concat(YEAR (TO_DATE (CURRENT_DATE, ‘YYYY-MM-DD’))-1,‘12’) “上年年末” --202112
from dummy