Days-to-End-of-Month - ibm.com
www.ibm.com › docs › enMar 20, 2007 · Days-to-End-of-Month Returns the number of days to the last day of the month from a date or datetime value. Syntax days-to-end-of-month (date_exp | datetime_exp) Example days-to-end-of-month (2007-03-20) Returns the result: 11 Parent topic:Date Functions
DAYS_TO_END_OF_MONTH - IBM
www.ibm.com › 11Feb 20, 2012 · The DAYS_TO_END_OF_MONTH function and datetime arithmetic with DAYS and LAST_DAY functions can be used to achieve the same results. The following examples demonstrate this. SET :NUMDAYS = DAYS(LAST_DAY(date '2013-02-20')) - DAYS(date '2013-02-20') SET :NUMDAYS = DAYS_TO_END_OF_MONTH(DATE '2013-02-20')