Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 08E129FB626 for ; Tue, 5 Jun 2007 15:25:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 79635-04 for ; Tue, 5 Jun 2007 15:25:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 47B4B9FB5CD for ; Tue, 5 Jun 2007 15:25:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1]) by svr4.postgresql.org (Postfix) with ESMTP id 3DFDC5AF861 for ; Tue, 5 Jun 2007 18:25:18 +0000 (GMT) Received: from [157.92.155.58] (unknown [157.92.155.58]) by fmed.uba.ar (Postfix) with ESMTP id 7709950A788 for ; Tue, 5 Jun 2007 15:37:17 -0300 (ART) Message-ID: <4665A4F6.8040501@fmed.uba.ar> Date: Tue, 05 Jun 2007 15:01:26 -0300 From: Gerardo Herzig User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: current_date / datetime stuff References: <46642A05.40708@joshuaneil.com> <20070604152736.GS32320@phlogiston.dyndns.org> <7B00D29F-089A-4A19-B9C1-0FF8A949DDA3@seespotcode.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/45 X-Sequence-Number: 28535 We should have a onliner contest. I love oneliners!!! > oneliner: > > select date_trunc('month',now()) + ((8 - extract('dow' from date_trunc > ('month',now()))||'days')::text)::interval; > > Kristo > On 04.06.2007, at 19:39, Michael Glaesemann wrote: >