Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C08059FB9C7 for ; Mon, 4 Jun 2007 12:05:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 98915-02-9 for ; Mon, 4 Jun 2007 12:04:49 -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 08E9C9FBAFC for ; Mon, 4 Jun 2007 12:04:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from randymail-a6.g.dreamhost.com (sd-green-bigip-207.dreamhost.com [208.97.132.207]) by svr4.postgresql.org (Postfix) with ESMTP id A15725AF03D for ; Mon, 4 Jun 2007 15:04:42 +0000 (GMT) Received: from [10.37.75.125] (unknown [204.252.154.241]) by randymail-a6.g.dreamhost.com (Postfix) with ESMTP id D0B62175C74 for ; Mon, 4 Jun 2007 08:04:40 -0700 (PDT) Message-ID: <46642A05.40708@joshuaneil.com> Date: Mon, 04 Jun 2007 10:04:37 -0500 From: Joshua User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: current_date / datetime stuff Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.15 tagged_above=0 required=5 tests=AWL=0.149, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200706/14 X-Sequence-Number: 28504 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