Re: getting last day of month

From: Sergey Moiseev <bopm(at)udaff(dot)com>
To: Sergey Pariev <egy(at)tnet(dot)dp(dot)ua>
Cc: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: getting last day of month
Date: 2005-08-25 13:58:53
Message-ID: 430DCE9D.6060508@udaff.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message josue 2005-08-25 14:05:53 Re: getting last day of month
Previous Message Tino Wildenhain 2005-08-25 13:19:19 Re: Postgresql replication