寂寞大萝卜 发表于 2016-11-17 06:24:25

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