DB2版本为:
select to_char(current date,'yyyymm') as "当前日期"
,TO_CHAR(TO_DATE(current date, 'YYYYMMDD') - 1 month, 'YYYY')||'01' as "年初一月"
,TO_CHAR(TO_DATE(current date, 'YYYYMMDD') - 1 month, 'YYYYMM') as "上个月"
,TO_CHAR(FIRST_DAY(current date) -1 day,'YYYYMMDD') as "上个月最后一天"
from SYSIBM.SYSDUMMY1