Hi,
Am trying to get the birthdays withing a period of time.
Having two dates I would like to get the ones whose birthdays are within that period no matter the year.
Select
name,
dob,
From Customers
where extract(day from dob) || '-' || extract(month from dob) = extract(day from date1) || '-' || extract(month from date2)
order by 1
How can I construct the query?
Thanks for the help!