Skip site navigation (1) Skip section navigation (2)

Date Question

From: Sharon Cowling <sharon(dot)cowling(at)sslnz(dot)com>
To: "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Date Question
Date: 2002-06-26 22:50:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I have a query that is not returning the desired results.  I want the results to be a list of permit_id's held between 2 dates, but the results I'm getting is only those permit_id's that start on date_from ('27-06-02') and finish on date_to ('11-07-02'), I also want the permit_id's returned for those permits that are held within that time period, for example a permit that starts on 20-06-02 and finishes on 04-07-02.  I've tried all sorts of variations but I'm still not getting the right results, anyone have any ideas?

SELECT permit_id
FROM faps_permit 
WHERE person_id = (select person_id from person where person_id = 100)
AND cancel_permit is null
AND location = 'Kent Forest'
AND ( (date_from >= '27-06-02' AND date_to <= '11-07-02') 
OR (date_from <= '27-06-02' AND date_to >= '11-07-02') )
ORDER BY permit_id ;

(Please note that this query is being used in a Java application and the values shown here are examples)

Sharon Cowling


pgsql-novice by date

Next:From: Tom LaneDate: 2002-06-26 23:11:52
Subject: Re: Can't get pg_hba.conf to work
Previous:From: Doug SilverDate: 2002-06-26 18:20:59
Subject: Can't get pg_hba.conf to work

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group