Hello List,
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
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