I'm attempting to pull up a birthday list of anyone born between, let's say June 15 and June 30th. The year is irrelevant.
I'm wondering if there is a more elegant way to do this than using something like:
SELECT key, dob from ds1.contact
extract(month FROM contact.dob ) = 6
and extract(day FROM contact.dob) >= 15
and extract(day FROM contact.dob) <= 30
Thanks for any suggestions...
Cascasde Data Solutions Inc.
pgsql-novice by date
|Next:||From: Steve Crawford||Date: 2012-03-13 22:09:22|
|Subject: Re: Date searching by month & day only|
|Previous:||From: Andrej||Date: 2012-03-13 19:55:31|
|Subject: Re: Updating RHEL4 system for PHP; requires Postgresql updates|