Last Day Function

Posted in 2006

Summary

leandro_logus asked how to get the last day of a month in Informix. Kernoal pointed to a June Hunt dates presentation from the Tampa 2006 conference. Richard Harnden and mehdi2 gave the approach: build a date with MDY for the first day of the following month and subtract one day. Eric posted a reply whose content was not shown.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

leandro_logus — Tue, 18 Jul 2006 12:54:57 -0500 — source: Usenet: comp.databases.informix

Hi, I'm have a problem, I would like know how return a last day of the month in db Informix . Thank you. leandro@logus-consultoria.com.br. -- leandro_logus ------------------------------------------------------------------------ leandro_logus's Profile: http://www.dbtalk.net/m544 View this thread: http://www.dbtalk.net/t319978

↪ replying to leandro_logus

Kernoal — 18 Jul 2006 11:14:10 -0700 — source: Usenet: comp.databases.informix

At the Tampa conference 2006, June Hunt did a session on dates with Informix. Very good presentation! It can be found @ www.iiug.org. FYI leandro_logus wrote: > Hi, I'm have a problem, I would like know how return a last day of the > month in db Informix . > > Thank you. > leandro@logus-consultoria.com.br. > > > -- > leandro_logus > ------------------------------------------------------------------------ > leandro_logus's Profile: http://www.dbtalk.net/m544 > View this thread: http://www.dbtalk.net/t319978

↪ replying to leandro_logus

Richard Harnden — Tue, 18 Jul 2006 19:17:14 +0100 — source: Usenet: comp.databases.informix

leandro_logus wrote: > Hi, I'm have a problem, I would like know how return a last day of the > month in db Informix . > Make a date, using MDY, as the first day of the next month and take one away. -- rh

↪ replying to Richard Harnden

Eric — 18 Jul 2006 12:26:00 -0700 — source: Usenet: comp.databases.informix

> leandro_logus wrote: > > Hi, I'm have a problem, I would like know how return a last day of the > > month in db Informix . > > Try this ----------------------------------------------------------------------------------------- create procedure lastDayOfMonth(dt date) returning date; return extend(extend(dt+1 units month,year to month)||"-01" ,year to day) - 1 units day; end procedure; execute procedure lastDayOfMonth(today);----------------------------------------------------------------------------------------- Eric Lam eric.lam@cobrasonic.com

↪ replying to leandro_logus

mehdi2@querix.com — Wed, 19 Jul 2006 10:05:29 +0100 — source: Usenet: comp.databases.informix

Hi Leandro; Consider, the last day of a month is the the first day of the following month - 1 day. On 18 Jul 2006 at 12:54, leandro_logus wrote: > > Hi, Im have a problem, I would like know how return a last day of the > month in db Informix . > > Thank you. > leandro@logus-consultoria.com.br. > > > -- > leandro_logus > ------------------------------------------------------------------------ > leandro_logus's Profile: http://www.dbtalk.net/m544 > View this thread: http://www.dbtalk.net/t319978 > >