Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1GJIHx45876 for ; Fri, 16 Feb 2001 14:18:17 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from admmail.uwaterloo.ca (admmail.uwaterloo.ca [129.97.128.31]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1FFVwx99821 for ; Thu, 15 Feb 2001 10:31:58 -0500 (EST) (envelope-from mrbyerle@uwaterloo.ca) Received: from odaapc17.uwaterloo.ca (odaapc17.uwaterloo.ca [129.97.19.162]) by admmail.uwaterloo.ca (8.9.3/8.9.3) with ESMTP id KAA75550 for ; Thu, 15 Feb 2001 10:31:54 -0500 Message-Id: <5.0.2.1.0.20010215102652.00a140a0@admmail.uwaterloo.ca> X-Sender: mrbyerle@admmail.uwaterloo.ca X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Thu, 15 Feb 2001 10:31:52 -0500 To: pgsql-sql@postgresql.org From: Mark Byerley Subject: Datetime Query Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200102/288 X-Sequence-Number: 1480 I need to create a query which will select a request_no between Data1 and Date2 so... SELECT request_no FROM request where status_code ='C' and (completed_date between 01/01/2000 and 01/01/2001); The problem I have run into is that the completed_date field is a datetime format (not by my own design) and I am having some problems extracting just the request_no's between those dates. I have tried a few extract month,day,year clauses with no success. If anyone has an idea I would appreciate it! Thanks in advance. Mark