DB2的sql里如何获取当前年月,如2008-04这个格式:
select left(cast((current date) as char(10)),7) from sysibm.sysdummy1
或者
values(left(cast((current date) as char(10)),7))
200804这种格式:
select substr(replace(cast((current date) as char(10)), '-', ''),1,6) from sysibm.sysdummy1
上面用到了函数:cast()、 left()、replace()、substr()