Re: Last day of month..

Posted in 1998

Octav Chiriac — Mon, 21 Sep 1998 17:39:41 +0300 (EETDST) — source: Informix-list mailing list archive (1991-1998)

Mark D. Stock wrote: >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 > OOPS, WRONG, WRONG !!!! What is the result for december dates ? @informix.com ??? To :-) OR :-( ??? Bye, Octav >|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"!|/ ////////| >+----------------------+-----------------------------------+-----------+ -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 20 96 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com