Re: Programming using 4GL

Posted in 1993

informix users bb — Tue, 6 Apr 93 16:31:56 MST — source: Informix-list mailing list archive (1991-1998)

Ruchi, hope this is helpful: to get date of the last day of the current month: select (MDY(MONTH(TODAY),1,YEAR(TODAY)) + 1 UNITS MONTH) - 1 UNITS DAY from systables where tabid = 1; to get day of the last day of the current month: select DAY((MDY(MONTH(TODAY),1,YEAR(TODAY)) + 1 UNITS MONTH) - 1 UNITS DAY) from systables where tabid = 1; regards, ------------------------------------------------------------------------------ | . . Bob Baskett | ... ... Software Engineer, DBA | ..... ..... Business Systems Integration Group | .. ... .. Semiconductor Products Sector | . . . Mesa, AZ | | Motorola, Inc ------------------------------------------------------------------------------ Sun 690-MP Informix Versions: Online - 5.00.UC2 ISQL - 4.10.UD1 4GL-RDS- 4.10.UC1 ------------------------------------------------------------------------------