根据出生日期计算年龄的公式 excel,sql根据出生日期计算年龄

System.Console.Write("请输入你的出生日期:"); string inputbirth = System.Console.ReadLine(); DateTime dtBirth = Convert.ToDateTime(inputbirth); DateTime dtNow = DateTime.Now; int days = ((TimeSpan)(dtNow - dtBirth)).Days; int iyears = days / 365; string result = String.Format("您的年龄：{0}周岁", iyears); if (iyears <= 0) { int month = days / 31; int adays = days % 31; if (month > 0) result = String.Format("您的年龄：{0}月{1}天", month, adays); else result = String.Format("您的年龄：{0}天", adays); }