日期的奇怪问题

找到问题，应该结贴啊！收起

我找到原因了，是日期格式的问题，db2 "select date(substr(char(date('2012-10-11')+1 month,ISO),1,8)||'01') -1 day from sysibm.sysdummy1"就可以了，谢谢大家了。收起

但我的写为什么就不行呢？怎么解释啊，程序里都是这是这种写法，不知道会不会出问题的。收起

--获取本月最后一天
values current timestamp + 1 months - day(current timestamp) days ;
values current timestamp - day(current timestamp) days + 1 days + 1 months - 1 days ;
values current timestamp + 1 months - day(current timestamp) days - hour(current timestamp) hours - minute(current timestamp) minutes - second(current timestamp) seconds - microsecond(current timestamp) microsecond ;
values current date + 1 months - day(current date + 1 months) days ;收起

C:\Documents and Settings\wangyax>db2 "select date(substr('2011-10-11',1,8)||'01') + 1 month - 1 day from sysibm.sysdumm
y1"
1
----------
2011-10-31
  1 条记录已选择。收起