Return a specific date

Database
Enthusiast

Return a specific date

How do I return the specific date of a persons 30th birthdate (past or future)

given the persons BIRTH_DATE?

I have a dataset of age ranges (24-64) and need to return the date of their 30th bday.

Thanks!

1 REPLY
Senior Apprentice

Re: Return a specific date

30 years are 360 months: ADD_MONTHS(BIRTH_DATE, 30*12)