Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A6C494768F3 for ; Thu, 26 Sep 2002 06:56:51 -0400 (EDT) Received: from ns.sni.ph (unknown [202.57.48.9]) by postgresql.org (Postfix) with ESMTP id 873E3476195 for ; Thu, 26 Sep 2002 06:56:49 -0400 (EDT) Received: (from root@localhost) by ns.sni.ph (8.11.6/8.11.6) id g8QAuoX21784 for pgsql-sql@postgresql.org; Thu, 26 Sep 2002 18:56:50 +0800 (PHT) Received: from tiger-work.sni.ph (tiger-work.sni.ph [202.57.48.24]) by ns.sni.ph (8.11.6/8.11.6) with ESMTP id g8QAumQ21720 for ; Thu, 26 Sep 2002 18:56:49 +0800 (PHT) Subject: start and end of the week From: John "Sebastian N. Mayordomo" To: "Pgsql-Sql@Postgresql. " Org X-scanner: scanned by SNI 1.0.10 - (http://www.sni.ph) Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 26 Sep 2002 18:56:46 +0800 Message-Id: <1033037809.16948.2.camel@tiger-work.sni.ph> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/322 X-Sequence-Number: 9599 How do I get the start and end date of the present week? Is this possible? For example this week Start = Sept. 22 End = Sept. 28 Thank you very much.