jzj41232216 发表于 2013-1-13 18:36:19

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（转）