Re: Need simple SQL to get the last day of month of previous month

[John Yeung <gallium.arsenide@xxxxxxxxx>]

On Thu, Oct 22, 2015 at 12:11 PM, CRPence <crpbottle@xxxxxxxxx> wrote:
>   An expression that obtains the last day of the prior month would be:
>
>      LAST_DAY(CURRENT DATE - 1 MONTH)
>
>   But because likely the unstated system-level being used is [probably
> still] v5r4, an alternate expression would be available as:
>
>      CURRENT DATE - DAYOFMONTH(CURRENT DATE) DAYS

I prefer this latter expression in any case, because it sidesteps any
conceivable confusion over what "1 month" means arithmetically. No
care has to be taken to, as Vern puts it, "half-adjust at the right
place".

John Y.