Received: from peacock.prod.itd.earthlink.net (peacock.prod.itd.earthlink.net [207.217.120.21]) by hub.org (8.10.1/8.10.1) with ESMTP id e83BPZC90411 for ; Sun, 3 Sep 2000 07:25:35 -0400 (EDT) Received: from hbg-dnt-1467.mindspring.com (fw-1.pas2.fw.mindspring.net [207.69.129.98]) by peacock.prod.itd.earthlink.net (8.9.3/8.9.3) with ESMTP id EAA16006; Sun, 3 Sep 2000 04:25:31 -0700 (PDT) Message-Id: <4.3.2.7.2.20000903072517.00c90b00@pop> X-Sender: bcdoyle@pop X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Sun, 03 Sep 2000 07:25:23 -0400 To: jmckown@prodigy.net From: "Brian C. Doyle" Subject: Re: Week of the Year? Cc: pgsql-sql@postgresql.org Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200009/5 John, Would you have any clue how to figure out the first saturday of any month - 6 days and the last saturday of that month? I know that this seems odd but i have to run reports for "Non Standard Months" and well I am clueless. At 09:55 PM 8/11/00 -0500, you wrote: >Try using the function date_part such as: > >select date_part('week',now()); > >"and the days that are in that week" I guess want to answer a question >such as: >Given a date, what is first date in that same week, and what is the last >date in that week. There are a couple of approaches to this. My first was: > >select >to_date(date_part('year',now()),'YYYY')+(7*date_part('week',now())); > >and the above +6 to the the last day of the week. Another approach for >this same question is much simplier (if the question is indeed what you >are asking) > >select now()-date_part('dow',now()); > >This last select gives the Sunday for the current week. To get the >Saturday, simply: > >select now()-date_part('dow',now())+6; > >Of course, replace the now() with whatever contains the date or timestamp. > >John McKown > > > I'm probably staring right at it. (One of the difficulties with RTFMing, is > > having too many docs!) > > > > Is there anything in the API that produces the week of the year, from 1 to > > 52 or 53 depending on the week of the year, and the days that are in that > > week? > > > > Many thanks. > > > > -dlj. > > > > > >