Avatar of morinia
morinia
Flag for United States of America asked on

Calculating age in Oracle query

Experts,

I have a column DOB which is on TableA   one of the tables I am reading into my Oracle query.  The query has multiple tables.  Can someone tell me how to calculate the age as of Dec 01, 2016.

I am using a pass-through query in SAS to read the Oracle tables.
Statistical Analysis System (SAS)

Avatar of undefined
Last Comment
Gerald Connolly

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Gerald Connolly

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61