zjxhx 发表于 2016-11-16 08:14:28

LAST_DAY, FIRST_DAY in DB2（）

last_day(sysdate) ==> values (current date + 1 month) - day(current date +1 month) days

first_day(sysdate) ==> values (current date - day(current date + 1 month) days) + 1 day
页: [1]
查看完整版本: LAST_DAY, FIRST_DAY in DB2（）