LAST_DAY, FIRST_DAY in DB2

by | Jan 25, 2008

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