How to check the age in months in where clause?

General

How to check the age in months in where clause?

Hi all,

 

I am a new teradata user and I am facing this problem of including only the patients who are atleast 6 months or older at the time of hospital visit.Could you please let me know any possible solution?

 

Thank you


Accepted Solutions
Highlighted
Senior Apprentice

Re: How to check the age in months in where clause?

Something like

WHERE birth_date < ADD_MONTHS(visit_date,-6)
1 ACCEPTED SOLUTION
2 REPLIES
Highlighted
Senior Apprentice

Re: How to check the age in months in where clause?

Something like

WHERE birth_date < ADD_MONTHS(visit_date,-6)

Re: How to check the age in months in where clause?

Thank you!