Re: Last day of month..

Posted in 1998

Mark D. Stock — Mon, 21 Sep 1998 12:41:27 +0200 — source: Informix-list mailing list archive (1991-1998)

SUNIL S. SINGH wrote: > > Hi All !! > > Is there any function or technique to find last day of month > ie 29 or 28 or 30 or 31 for a particular date(dd/mm/yy) Try: SELECT DAY(MDY(MONTH(TODAY)+1,1,YEAR(TODAY))-1) FROM systables WHERE tabid = 1 Where 'a particular date' is TODAY. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+