DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=PDuGm68bcQlkNXIyzs+/lcl9CULtTNxxNS+XnJFltnm84WCggFwNlhuV4/+kMSyKeQBSZR9Vr5J1kbngWdXMQ0koJ7TT7Lp25oCcim4ZY+gdC0cN9ac2TPUAfGa9XE7FEshPMcii2zTUeBKj4p7ALImvUZl7okdL6V8BYmHsdDY=
Message-ID: <a55915760706040925n5c8286f9t7e11989ca22559ab@mail.gmail.com>
Date: Mon, 4 Jun 2007 11:25:51 -0500
From: "=?UTF-8?Q?Rodrigo_De_Le=C3=B3n?=" <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org, Joshua <joshua@joshuaneil.com>
Subject: Re: current_date / datetime stuff
In-Reply-To: <46642A05.40708@joshuaneil.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <46642A05.40708@joshuaneil.com>

On 6/4/07, Joshua <joshua@joshuaneil.com> wrote:
> Hello,
>
> I was hoping someone here may be able to help me out with this one:
>
> Is there anything similiar to:     SELECT current_date;
> that will return the date of the first Monday of the month?
>
> Please let me know.
>
> Thanks,
> Joshua

select (
  select
  case i <= dow
    when true  then d + (i - dow + 7)
    when false then d + (i - dow)
  end
  from (
    select d
    , extract(dow from d)::int as dow
    , 1 as i -- monday
    from (
      select date_trunc('month',current_date)::date - 1 as d
    ) q
  ) q2
) as first_monday_of_the_month