Re: getting last day of month - Mailing list pgsql-general

From Sergey Moiseev
Subject Re: getting last day of month
Date
Msg-id 430DCE9D.6060508@udaff.com
Whole thread Raw
In response to getting last day of month  (Sergey Pariev <egy@tnet.dp.ua>)
List pgsql-general
Sergey Pariev wrote:
> Hi all.
> I need to find out the last day of current month. Currently I do the
> trick with code below, but that's rather ugly way to do it IMHO. Could
> anybody suggest me a better way ?
select '2005-09-01'::date-'1 day'::interval does the trick :)
--
Wbr, Sergey Moiseev

pgsql-general by date:

Previous
From: Sergey Pariev
Date:
Subject: getting last day of month
Next
From: Tino Wildenhain
Date:
Subject: Re: getting last day of month