Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f54IurE72594 for ; Mon, 4 Jun 2001 14:56:54 -0400 (EDT) (envelope-from ler@lerctr.org) Received: from ler-freebie.iadfw.net (ler-freebie.iadfw.net [206.66.13.221]) by lerami.lerctr.org (8.12.0.Beta7/8.12.0.Beta7/20010318/$Revision: 1.22 $) with SMTP id f54IudsY023397; Mon, 4 Jun 2001 13:56:39 -0500 (CDT) (envelope-from ler@lerctr.org) From: Larry Rosenman Date: Mon, 04 Jun 2001 18:56:39 GMT Message-ID: <20010604.18563900@ler-freebie.iadfw.net> Subject: Re: SQL Date Challenge To: Manuel Sugawara CC: Josh Berkus , pgsql-sql@postgresql.org In-Reply-To: References: X-Mailer: Mozilla/3.0 (compatible; StarOffice/5.2;Linux) X-Priority: 3 (Normal) MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f54IusE72601 X-Archive-Number: 200106/24 X-Sequence-Number: 3227 SELECT whatever from xx where extract(dow from date) = 3; LER >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 6/4/01, 1:03:11 PM, Manuel Sugawara wrote regarding Re: [SQL] SQL Date Challenge: > "Josh Berkus" writes: > > > > SELECT ALL Wednesdays BETWEEN 5/1/01 AND 6/1/01; > > > somthing like: > select date from xx where to_char(date,'fmdy') = 'wed'; > hth, > Manuel. > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org