Create Age variable

Question

Hello,&nbsp;I have a table called acrsdw.person with a DOB (date of birth variable). I want to create an age variable. However, there are two conditions I can not alter the table and I can not create a new table due to permissions issues. Is there any other way?&nbsp;&nbsp;

josé dr · Answer

Kammy89Create a view that calculates age.https://learn.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql

Forum Discussion

Create Age variable

Share