Received: from mc-qout2.whowhere.com (nytoday.whowhere.com [209.1.236.38]) by hub.org (8.10.1/8.10.1) with SMTP id e5O5FB102981 for ; Sat, 24 Jun 2000 01:15:11 -0400 (EDT) Received: from Unknown/Local ([?.?.?.?]) by shared1-mail.whowhere.com; Fri Jun 23 22:14:42 2000 To: pgsql-sql@hub.org Date: Fri, 23 Jun 2000 22:14:42 -0700 From: "K Parker" Message-ID: Mime-Version: 1.0 X-Sent-Mail: on Reply-To: kparker@eudoramail.com X-Mailer: MailCity Service Subject: Re: Wildcard in date field X-Sender-Ip: 209.191.185.54 Organization: QUALCOMM Eudora Web-Mail (http://www.eudoramail.com:80) Content-Type: text/plain; charset=us-ascii Content-Language: en Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/217 The suggest solution works: > SELECT * FROM my_table WHERE > date_part('month', col_name::datetime) = '06' > AND date_part('year', col_name::datetime) = > '2000'; But you can also just do a comparison: where col_name >= '2000-06-01' AND col_name <= '2000-06-30' Using the correct date format for your environment, of course. Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com