SQL statement for last day of the month - t.log [1/1]

The following is a pure SQL solution -- no (3gl, 4gl nor host) procedure calls: OUTPUT: ------------------------------------------------------------------------------ SELECT TODAY AS current_date ,MDY( MONTH( TODAY ), 1, YEAR( TODAY ) ) AS first_day_of_mo ,MDY( MONTH( TODAY ), 1, YEAR( TODAY ) ) + 1 UNITS MONTH - 1 UNITS DAY AS last_day_of_mo ,DATE( MDY( MONTH( TODAY ), 1, YEAR( TODAY ) ) + 1 UNITS MONTH - 1 UNITS DAY ) AS last_day_of_mo2 ,DATE( '12/3/95' ) AS dec_date ,MDY( MONTH( DATE( '12/3/95') ), 1, YEAR( DATE( '12/3/95') ) ) AS first_day_of_dec ,MDY( MONTH( DATE( '12/3/95') ), 1, YEAR( DATE( '12/3/95') ) ) + 1 UNITS MONTH - 1 UNITS DAY AS last_day_of_dec ,DATE( MDY( MONTH( DATE( '12/3/95') ), 1, YEAR( DATE( '12/3/95') ) ) + 1 UNITS MONTH - 1 UNITS DAY ) AS last_day_of_dec2 FROM informix.systables WHERE tabid = 1; current_date 02/12/1996 first_day_of_mo 02/01/1996 last_day_of_mo 1996-02-29 last_day_of_mo2 02/29/1996 dec_date 12/03/1995 first_day_of_dec 12/01/1995 last_day_of_dec 1995-12-31 last_day_of_dec2 12/31/1995 ------------------------------------------------------------------------------ By re-casting the date result to date [DATE()] the format matches the first_day format in the interactive SQL (dbacces & isql) output. ( I am new to INFORMIX, so there maybe other INFORMIX short-cuts or FORMAT variables that I am unaware of.)