Avatar of Charles Baldo
Charles Baldo
Flag for United States of America

asked on 

SQL Need to calculate age from DOB, no stored procedures or functions allowed

I need to calculate exact age from today.  It must be in T-SQL I can not create a store procedure or function.  Another twist is the date as stored in a Varchar(255) type.   It has a format like  YYYY-mm-dd  ex 1971-02-12.  The database is SQL 2005.

Thank You
Microsoft SQL Server 2005Microsoft SQL ServerHIPAA

Avatar of undefined
Last Comment
Charles Baldo

8/22/2022 - Mon