Date searching by month & day only

Hello List,

I’m attempting to pull up a birthday list of anyone born between, let’s say June 15 and June 30^th.  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

WHERE

extract(month FROM contact.dob ) = 6

and extract(day FROM contact.dob) >= 15

and extract(day FROM contact.dob) <= 30

Thanks for any suggestions…

Regards,

Chris Campbell

Cascasde Data Solutions Inc.

800.280.2090

ccampbell@cascadeds.com