getting dates in the past

From: garry saddington <garry(at)schoolteachers(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: getting dates in the past
Date: 2006-09-25 20:59:25
Message-ID: 1159217965.30096.46.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How could I translate this into sql?

select result from results
where date_entered between (last september and the one before that)

Its the part in brackets that has me guessing. I am still experimenting
but any help will be gratefully recieved.
Kind Regards
Garry

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-09-25 21:05:34 Re: What is the Best Postgresql Load Balancing Solution
Previous Message Nikolay Samokhvalov 2006-09-25 20:17:35 Re: What is the Best Postgresql Load Balancing Solution available ?