Extract between year *and* month - Mailing list pgsql-general

From One
Subject Extract between year *and* month
Date
Msg-id 1163711000.616007.67660@k70g2000cwa.googlegroups.com
Whole thread Raw
Responses Re: Extract between year *and* month  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Extract between year *and* month  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-general
Hi - I'd like to return search results based on a date range that is
selected by the user :

<select name="date1yy">
       <option value="1995-01-01" selected>1995</option>

<select name="date2yy">
       <option value="2006-12-31" selected>2006</option>

My SQL is :

select *
 from tablename
    where title like ('%nith%')
       and recall_date between
           extract(year from date '1995-01-01')
              and  extract(year from date '2006-12-31')
                  order by recall_date

How can I add the MONTH to be included in the between statement ?
If I select 1995 - 2006 it currently only returns rows up to 2005-12-31

THANKS!


pgsql-general by date:

Previous
From: gustavo halperin
Date:
Subject: wxWidgets and arrays
Next
From: "Alain Roger"
Date:
Subject: set the default schema