var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Informix Date Functions
I am looking for the equivalent of 'LAST_DAY' function (Oracle) in Informix.
Can any one help?
i don't use informix but a quick search of their online docs turned up the MDY() function that can be adapted to what you want
use the expression MDY(MONTH(TODAY),28,YEAR(TODAY)) + INTERVAL (4) DAY to put you into the next month
use MDY(MONTH(XX),1,YEAR(XX)) to get the first day of the next month (where XX is the expression above) and then subtract 1 day
not pretty, but i think that'll do it
Thanks for you suggestion but have come up with more tidy
peace of code. If you are interested here is the solution I am
MDY(MOD(Month(today)+1,12),1,year(today)) -1 units day
Thanks again for you help
you sure that'll work in december? i think you might end up with december 31 of the previous year, eh?
another date code
There is one more way......
((TODAY) + 1 UNITS MONTH - (DAY(TODAY)) UNITS DAY)
this will eliminate the problem when you hit december...