Datetime Query

From: Mark Byerley <mrbyerle(at)uwaterloo(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Datetime Query
Date: 2001-02-15 15:31:52
Message-ID: 5.0.2.1.0.20010215102652.00a140a0@admmail.uwaterloo.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message mike 2001-02-15 16:18:08 Re: what means "INSERT xxx yyy" ?
Previous Message Tom Lane 2001-02-15 15:15:27 Re: TPCH questions