Re: Last day of month..

Posted in 1998

GAC — Mon, 21 Sep 1998 08:04:22 -0400 — source: Informix-list mailing list archive (1991-1998)

According to the ANSI text book on SQL I'm studying you could try: "SQL> SELECT ENDDATE, LAST_DAY(ENDDATE) 2 FROM PROJECT;" LAST_DAY being the function that finds the last day of the month. As always check your implementation. >>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) >> >Octav Chiriac wrote: >Let's say our date is m_date: >DAY(MDY(MONTH(m_date), 1, YEAR(m_date)) + 1 UNITS MONTH) - 1 >UNITS DAY) ------- Stan Hixon Postcript-DBA GAC-Atlanta hixons@cgprinting.com