From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | Mark Byerley <mrbyerle(at)uwaterloo(dot)ca> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Datetime Query |
Date: | 2001-02-16 21:45:26 |
Message-ID: | Pine.BSF.4.10.10102161342210.69460-100000@tidal.ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Try:
SELECT request_no FROM request where status_code ='C' and
(completed_date::date
between '01/01/2000'::date and '01/01/2001'::date)
actually date('01/01/2000') does same thing as '01/01/2000'::date
Jie LIANG
St. Bernard Software
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com
On Thu, 15 Feb 2001, Mark Byerley wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2001-02-16 21:49:16 | Re: Help Retrieving Latest Record |
Previous Message | Dorin Grunberg | 2001-02-16 21:35:44 | Re: Help Retrieving Latest Record |