I'm using "datediff(yyyy,val_date,getdate()) as age"
formula to calculate the age.
If the bdate is in this year like "2005-03-09"(5 months old)
or"2005-05-21"(6 days) old.
Is it possible to calculate the age in months & days also in athe same datediff formula?
formula to calculate the age.
If the bdate is in this year like "2005-03-09"(5 months old)
or"2005-05-21"(6 days) old.
Is it possible to calculate the age in months & days also in athe same datediff formula?